Overview

Dataset info

Number of variables183
Number of observations566
Missing cells35172 (34.0%)
Duplicate rows0 (0.0%)
Total size in memory771.7 KiB
Average record size in memory1.4 KiB

Variables types

Numeric70
Categorical23
Boolean28
Date0
URL0
Text (Unique)1
Rejected61
Unsupported0

Warnings

coligada_mais_antiga_ativa has 267 (47.2%) missing values Missing
coligada_mais_antiga_baixada has 565 (99.8%) missing values Missing
coligada_mais_nova_ativa has 267 (47.2%) missing values Missing
coligada_mais_nova_baixada has 565 (99.8%) missing values Missing
de_indicador_telefone has 125 (22.1%) missing values Missing
de_saude_rescencia has constant value "ACIMA DE 1 ANO" Rejected
dt_situacao only contains datetime values, but is categorical. Consider applying pd.to_datetime()Type
dt_situacao has a high cardinality: 207 distinct values Warning
empsetorcensitariofaixarendapopulacao has 70 (12.4%) missing values Missing
faturamento_est_coligados has 273 (48.2%) missing values Missing
faturamento_est_coligados_gp is highly correlated with faturamento_est_coligados (ρ = 0.967174556) Rejected
fl_epp has constant value "False" Rejected
fl_matriz has constant value "True" Rejected
fl_mei has constant value "False" Rejected
fl_optante_simei has constant value "False" Rejected
grau_instrucao_macro_analfabeto has 449 (79.3%) missing values Missing
grau_instrucao_macro_desconhecido has constant value "nan" Rejected
grau_instrucao_macro_escolaridade_fundamental has 48 (8.5%) missing values Missing
grau_instrucao_macro_escolaridade_superior has 17 (3.0%) missing values Missing
idade_acima_de_58 has 61 (10.8%) missing values Missing
idade_ate_18 has 351 (62.0%) missing values Missing
idade_de_19_a_23 has 94 (16.6%) missing values Missing
idade_de_24_a_28 has 17 (3.0%) missing values Missing
idade_de_39_a_43 is highly correlated with idade_de_34_a_38 (ρ = 0.9590517955) Rejected
idade_de_44_a_48 is highly correlated with idade_de_39_a_43 (ρ = 0.9834234363) Rejected
idade_de_49_a_53 is highly correlated with idade_de_44_a_48 (ρ = 0.9902727483) Rejected
idade_de_54_a_58 is highly correlated with idade_de_49_a_53 (ρ = 0.9851407204) Rejected
idade_maxima_coligadas is highly correlated with coligada_mais_antiga_ativa (ρ = 0.9991113517) Rejected
idade_maxima_socios has 213 (37.6%) missing values Missing
idade_media_coligadas has 267 (47.2%) missing values Missing
idade_media_coligadas_ativas is highly correlated with idade_media_coligadas (ρ = 0.9994986426) Rejected
idade_media_coligadas_baixadas has 565 (99.8%) missing values Missing
idade_media_socios has 213 (37.6%) missing values Missing
idade_minima_coligadas is highly correlated with coligada_mais_nova_ativa (ρ = 0.9996293323) Rejected
idade_minima_socios has 213 (37.6%) missing values Missing
max_faturamento_est_coligados has 273 (48.2%) missing values Missing
max_faturamento_est_coligados_gp is highly correlated with max_faturamento_est_coligados (ρ = 0.9487331088) Rejected
max_filiais_coligados is highly correlated with max_faturamento_est_coligados_gp (ρ = 0.9209527542) Rejected
max_funcionarios_coligados_gp is highly correlated with max_filiais_coligados (ρ = 0.9596800847) Rejected
max_vl_folha_coligados has 332 (58.7%) missing values Missing
max_vl_folha_coligados_gp is highly correlated with max_faturamento_est_coligados_gp (ρ = 0.932597259) Rejected
media_faturamento_est_coligados has 273 (48.2%) missing values Missing
media_faturamento_est_coligados_gp is highly correlated with media_faturamento_est_coligados (ρ = 0.9755334699) Rejected
media_filiais_coligados is highly correlated with media_faturamento_est_coligados_gp (ρ = 0.9378844305) Rejected
media_funcionarios_coligados_gp is highly correlated with media_filiais_coligados (ρ = 0.9763654488) Rejected
media_vl_folha_coligados has 332 (58.7%) missing values Missing
media_vl_folha_coligados_gp is highly correlated with media_faturamento_est_coligados_gp (ρ = 0.9398249993) Rejected
min_faturamento_est_coligados has 273 (48.2%) missing values Missing
min_faturamento_est_coligados_gp is highly correlated with min_faturamento_est_coligados (ρ = 0.947631243) Rejected
min_filiais_coligados has 413 (73.0%) missing values Missing
min_funcionarios_coligados_gp has 93 (16.4%) zeros Zeros
min_funcionarios_coligados_gp has 314 (55.5%) missing values Missing
min_meses_servicos is highly correlated with meses_ultima_contratacaco (ρ = 0.983480359) Rejected
min_meses_servicos_all has 35 (6.2%) zeros Zeros
min_vl_folha_coligados is highly correlated with media_vl_folha_coligados (ρ = 0.9271743681) Rejected
min_vl_folha_coligados_gp is highly correlated with min_vl_folha_coligados (ρ = 0.9564480986) Rejected
nm_divisao has a high cardinality: 60 distinct values Warning
nm_meso_regiao has 70 (12.4%) missing values Missing
nm_micro_regiao has a high cardinality: 61 distinct values Warning
nm_micro_regiao has 70 (12.4%) missing values Missing
qt_admitidos_12meses has 199 (35.2%) zeros Zeros
qt_alteracao_socio_180d has constant value "nan" Rejected
qt_alteracao_socio_365d has constant value "nan" Rejected
qt_alteracao_socio_90d has constant value "nan" Rejected
qt_alteracao_socio_total has constant value "nan" Rejected
qt_art has 304 (53.7%) missing values Missing
qt_coligadas has 267 (47.2%) missing values Missing
qt_coligados is highly correlated with qt_coligadas (ρ = 0.9999953678) Rejected
qt_coligados_agropecuaria has 265 (46.8%) zeros Zeros
qt_coligados_agropecuaria has 267 (47.2%) missing values Missing
qt_coligados_atividade_alto has 267 (47.2%) missing values Missing
qt_coligados_atividade_baixo has 267 (47.2%) missing values Missing
qt_coligados_atividade_inativo has 267 (47.2%) missing values Missing
qt_coligados_atividade_medio has 267 (47.2%) missing values Missing
qt_coligados_atividade_mt_baixo has 267 (47.2%) missing values Missing
qt_coligados_ativo is highly correlated with qt_coligados (ρ = 0.9998350326) Rejected
qt_coligados_baixada has 267 (47.2%) missing values Missing
qt_coligados_ccivil has 220 (38.9%) zeros Zeros
qt_coligados_ccivil has 267 (47.2%) missing values Missing
qt_coligados_centro has 272 (48.1%) zeros Zeros
qt_coligados_centro has 267 (47.2%) missing values Missing
qt_coligados_comercio has 152 (26.9%) zeros Zeros
qt_coligados_comercio has 267 (47.2%) missing values Missing
qt_coligados_epp has 267 (47.2%) missing values Missing
qt_coligados_exterior has 267 (47.2%) missing values Missing
qt_coligados_inapta has 267 (47.2%) missing values Missing
qt_coligados_industria has 211 (37.3%) zeros Zeros
qt_coligados_industria has 267 (47.2%) missing values Missing
qt_coligados_ltda has 286 (50.5%) zeros Zeros
qt_coligados_ltda has 267 (47.2%) missing values Missing
qt_coligados_matriz is highly correlated with qt_coligados_ativo (ρ = 0.9990425998) Rejected
qt_coligados_me has 267 (47.2%) missing values Missing
qt_coligados_mei has 267 (47.2%) missing values Missing
qt_coligados_nordeste has 141 (24.9%) zeros Zeros
qt_coligados_nordeste has 267 (47.2%) missing values Missing
qt_coligados_norte has 159 (28.1%) zeros Zeros
qt_coligados_norte has 267 (47.2%) missing values Missing
qt_coligados_nula has 267 (47.2%) missing values Missing
qt_coligados_sa is highly correlated with qt_coligados_industria (ρ = 0.9295712651) Rejected
qt_coligados_serviço has 61 (10.8%) zeros Zeros
qt_coligados_serviço has 267 (47.2%) missing values Missing
qt_coligados_sudeste is highly correlated with qt_coligados_matriz (ρ = 0.9286701513) Rejected
qt_coligados_sul has 287 (50.7%) zeros Zeros
qt_coligados_sul has 267 (47.2%) missing values Missing
qt_coligados_suspensa has 267 (47.2%) missing values Missing
qt_desligados_12meses has 187 (33.0%) zeros Zeros
qt_ex_funcionarios is highly correlated with qt_desligados (ρ = 0.9999984378) Rejected
qt_filiais has 270 (47.7%) zeros Zeros
qt_funcionarios is highly correlated with idade_de_54_a_58 (ρ = 0.9473213605) Rejected
qt_funcionarios_12meses is highly correlated with qt_funcionarios (ρ = 0.9976051149) Rejected
qt_funcionarios_24meses is highly correlated with qt_funcionarios_12meses (ρ = 0.9833377759) Rejected
qt_funcionarios_coligados has 18 (3.2%) zeros Zeros
qt_funcionarios_coligados has 314 (55.5%) missing values Missing
qt_funcionarios_coligados_gp is highly correlated with media_filiais_coligados (ρ = 0.9060538336) Rejected
qt_funcionarios_grupo is highly skewed (γ1 = 21.81140653) Skewed
qt_ramos_coligados has 267 (47.2%) missing values Missing
qt_regioes_coligados has 267 (47.2%) missing values Missing
qt_socios has 184 (32.5%) missing values Missing
qt_socios_coligados is highly correlated with qt_coligados_matriz (ρ = 0.9679088493) Rejected
qt_socios_feminino is highly correlated with qt_socios (ρ = 0.98778012) Rejected
qt_socios_masculino is highly correlated with qt_socios_feminino (ρ = 0.96613456) Rejected
qt_socios_pep is highly correlated with qt_socios_masculino (ρ = 0.9767644238) Rejected
qt_socios_pf is highly correlated with qt_socios_pep (ρ = 0.9745025748) Rejected
qt_socios_pj has 184 (32.5%) missing values Missing
qt_socios_pj_ativos is highly correlated with qt_socios_pj (ρ = 0.962828788) Rejected
qt_socios_pj_baixados has 515 (91.0%) missing values Missing
qt_socios_pj_inaptos has 515 (91.0%) missing values Missing
qt_socios_pj_nulos has 515 (91.0%) missing values Missing
qt_socios_pj_suspensos has 515 (91.0%) missing values Missing
qt_socios_st_regular is highly correlated with qt_socios_pf (ρ = 0.9943253402) Rejected
qt_socios_st_suspensa has 565 (99.8%) missing values Missing
qt_ufs_coligados has 267 (47.2%) missing values Missing
sg_uf_matriz is a recoding of sg_ufRejected
sum_faturamento_estimado_coligadas is highly correlated with faturamento_est_coligados_gp (ρ = 0.96717436) Rejected
total is highly correlated with qt_funcionarios_24meses (ρ = 0.9784337577) Rejected
total_filiais_coligados is highly correlated with qt_funcionarios_coligados_gp (ρ = 0.9215779475) Rejected
tx_crescimento_12meses has 195 (34.5%) zeros Zeros
tx_crescimento_24meses is highly correlated with qt_socios_pep (ρ = 0.9638549677) Rejected
tx_rotatividade has 188 (33.2%) zeros Zeros
Unnamed_0_y is highly correlated with Unnamed_0_x (ρ = 0.9992144689) Rejected
vl_folha_coligados is highly correlated with qt_funcionarios_coligados (ρ = 0.9216477572) Rejected
vl_folha_coligados_gp is highly correlated with max_vl_folha_coligados_gp (ρ = 0.9057230661) Rejected
vl_frota has 98 (17.3%) missing values Missing
vl_idade_maxima_socios_pj has 515 (91.0%) missing values Missing
vl_idade_media_socios_pj is highly correlated with vl_idade_maxima_socios_pj (ρ = 0.9332295218) Rejected
vl_idade_minima_socios_pj is highly correlated with vl_idade_media_socios_pj (ρ = 0.9251854481) Rejected
vl_potenc_cons_oleo_gas has 472 (83.4%) missing values Missing
vl_total_tancagem is highly correlated with vl_potenc_cons_oleo_gas (ρ = 0.9431314001) Rejected
vl_total_tancagem_grupo has 536 (94.7%) missing values Missing
vl_total_veiculos_antt is highly correlated with vl_total_tancagem_grupo (ρ = 0.9643989074) Rejected
vl_total_veiculos_antt_grupo is highly correlated with vl_total_veiculos_antt (ρ = 1) Rejected
vl_total_veiculos_leves has 47 (8.3%) zeros Zeros
vl_total_veiculos_leves has 76 (13.4%) missing values Missing
vl_total_veiculos_leves_grupo is highly correlated with vl_total_veiculos_leves (ρ = 0.9590222257) Rejected
vl_total_veiculos_pesados has 165 (29.2%) zeros Zeros
vl_total_veiculos_pesados has 76 (13.4%) missing values Missing
vl_total_veiculos_pesados_grupo has 237 (41.9%) zeros Zeros

Variables

coligada_mais_antiga_ativa
Numeric

Distinct count292
Unique (%)51.6%
Missing (%)47.2%
Missing (n)267
Infinite (%)0.0%
Infinite (n)0
Mean299.8681159
Minimum2.766666667
Maximum1135.233333
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2.766666667
5-th percentile35.37
Q1151.2666667
Median275.4666667
Q3432.65
95-th percentile630.8933333
Maximum1135.233333
Range1132.466667
Interquartile range281.3833333

Descriptive statistics

Standard deviation187.5005989
Coef of variation0.6252768766
Kurtosis0.1684328582
Mean299.8681159
MAD153.4905724
Skewness0.5572336143
Sum89660.56667
Variance35156.4746
Memory size8.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
101.8333333 2 0.4%
 
635.2333333 2 0.4%
 
657.8666667 2 0.4%
 
261.0333333 2 0.4%
 
186.8 2 0.4%
 
500.1333333 2 0.4%
 
438.7333333 2 0.4%
 
634.5 2 0.4%
 
29.3 1 0.2%
 
265.9333333 1 0.2%
 
Other values (281) 281 49.6%
 
(Missing) 267 47.2%
 

Minimum 5 values

ValueCountFrequency (%) 
2.766666667 1 0.2%
 
5.8 1 0.2%
 
8.933333333 1 0.2%
 
11.13333333 1 0.2%
 
17.13333333 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
1135.233333 1 0.2%
 
674.9333333 1 0.2%
 
657.8666667 2 0.4%
 
642.6666667 1 0.2%
 
636.8333333 1 0.2%
 

coligada_mais_antiga_baixada
Categorical

Distinct count2
Unique (%)0.4%
Missing (%)99.8%
Missing (n)565
190.9
 
1
(Missing)
565
ValueCountFrequency (%) 
190.9 1 0.2%
 
(Missing) 565 99.8%
 
Max length5
Mean length3.003533569
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

coligada_mais_nova_ativa
Numeric

Distinct count282
Unique (%)49.8%
Missing (%)47.2%
Missing (n)267
Infinite (%)0.0%
Infinite (n)0
Mean86.91125975
Minimum1.5
Maximum614
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1.5
5-th percentile3.19
Q121.36666667
Median56.2
Q3116.25
95-th percentile287.8966667
Maximum614
Range612.5
Interquartile range94.88333333

Descriptive statistics

Standard deviation91.5564336
Coef of variation1.053447319
Kurtosis4.798653623
Mean86.91125975
MAD66.98703296
Skewness1.920398615
Sum25986.46667
Variance8382.580533
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
56.9 2 0.4%
 
172.4 2 0.4%
 
14.56666667 2 0.4%
 
2.033333333 2 0.4%
 
2.766666667 2 0.4%
 
237.4333333 2 0.4%
 
114.1666667 2 0.4%
 
186.8 2 0.4%
 
47.8 2 0.4%
 
17.93333333 2 0.4%
 
Other values (271) 279 49.3%
 
(Missing) 267 47.2%
 

Minimum 5 values

ValueCountFrequency (%) 
1.5 2 0.4%
 
1.6 1 0.2%
 
1.966666667 1 0.2%
 
2.033333333 2 0.4%
 
2.4 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
614 1 0.2%
 
424.6333333 1 0.2%
 
378.1333333 1 0.2%
 
377.9 1 0.2%
 
368.8666667 1 0.2%
 

coligada_mais_nova_baixada
Categorical

Distinct count2
Unique (%)0.4%
Missing (%)99.8%
Missing (n)565
190.9
 
1
(Missing)
565
ValueCountFrequency (%) 
190.9 1 0.2%
 
(Missing) 565 99.8%
 
Max length5
Mean length3.003533569
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

de_faixa_faturamento_estimado
Categorical

Distinct count6
Unique (%)1.1%
Missing (%)0.0%
Missing (n)0
DE R$ 10.000.000,01 A R$ 30.000.000,00
278
DE R$ 30.000.000,01 A R$ 100.000.000,00
202
DE R$ 100.000.000,01 A R$ 300.000.000,00
58
Other values (3)
 
28
ValueCountFrequency (%) 
DE R$ 10.000.000,01 A R$ 30.000.000,00 278 49.1%
 
DE R$ 30.000.000,01 A R$ 100.000.000,00 202 35.7%
 
DE R$ 100.000.000,01 A R$ 300.000.000,00 58 10.2%
 
DE R$ 300.000.000,01 A R$ 500.000.000,00 15 2.7%
 
DE R$ 500.000.000,01 A 1 BILHAO DE REAIS 8 1.4%
 
ACIMA DE 1 BILHAO DE REAIS 5 0.9%
 
Max length40
Mean length38.53710247
Min length26
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

de_faixa_faturamento_estimado_grupo
Categorical

Distinct count6
Unique (%)1.1%
Missing (%)0.0%
Missing (n)0
DE R$ 10.000.000,01 A R$ 30.000.000,00
247
DE R$ 30.000.000,01 A R$ 100.000.000,00
210
DE R$ 100.000.000,01 A R$ 300.000.000,00
78
Other values (3)
 
31
ValueCountFrequency (%) 
DE R$ 10.000.000,01 A R$ 30.000.000,00 247 43.6%
 
DE R$ 30.000.000,01 A R$ 100.000.000,00 210 37.1%
 
DE R$ 100.000.000,01 A R$ 300.000.000,00 78 13.8%
 
DE R$ 300.000.000,01 A R$ 500.000.000,00 14 2.5%
 
DE R$ 500.000.000,01 A 1 BILHAO DE REAIS 9 1.6%
 
ACIMA DE 1 BILHAO DE REAIS 8 1.4%
 
Max length40
Mean length38.55830389
Min length26
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

de_indicador_telefone
Categorical

Distinct count2
Unique (%)0.4%
Missing (%)22.1%
Missing (n)125
BOA
441
(Missing)
125
ValueCountFrequency (%) 
BOA 441 77.9%
 
(Missing) 125 22.1%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

de_natureza_juridica
Categorical

Distinct count26
Unique (%)4.6%
Missing (%)0.0%
Missing (n)0
SOCIEDADE EMPRESARIA LIMITADA
287
MUNICIPIO
110
EMPRESA INDIVIDUAL DE RESPONSABILIDADE LIMITADA DE NATUREZA EMPRESARIA
 
31
Other values (23)
138
ValueCountFrequency (%) 
SOCIEDADE EMPRESARIA LIMITADA 287 50.7%
 
MUNICIPIO 110 19.4%
 
EMPRESA INDIVIDUAL DE RESPONSABILIDADE LIMITADA DE NATUREZA EMPRESARIA 31 5.5%
 
SOCIEDADE ANONIMA FECHADA 21 3.7%
 
ASSOCIACAO PRIVADA 21 3.7%
 
ORGAO PUBLICO DO PODER EXECUTIVO ESTADUAL OU DO DISTRITO FEDERAL 19 3.4%
 
ORGAO PUBLICO DO PODER EXECUTIVO MUNICIPAL 12 2.1%
 
EMPRESARIO INDIVIDUAL 10 1.8%
 
SERVICO SOCIAL AUTONOMO 6 1.1%
 
SOCIEDADE SIMPLES LIMITADA 6 1.1%
 
Other values (16) 43 7.6%
 
Max length70
Mean length27.89575972
Min length9
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

de_nivel_atividade
Categorical

Distinct count3
Unique (%)0.5%
Missing (%)0.0%
Missing (n)0
ALTA
523
MEDIA
 
37
BAIXA
 
6
ValueCountFrequency (%) 
ALTA 523 92.4%
 
MEDIA 37 6.5%
 
BAIXA 6 1.1%
 
Max length5
Mean length4.075971731
Min length4
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

de_ramo
Categorical

Distinct count29
Unique (%)5.1%
Missing (%)0.0%
Missing (n)0
ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL
163
COMERCIO VAREJISTA
 
46
INDUSTRIA DA CONSTRUCAO
 
46
Other values (26)
311
ValueCountFrequency (%) 
ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL 163 28.8%
 
COMERCIO VAREJISTA 46 8.1%
 
INDUSTRIA DA CONSTRUCAO 46 8.1%
 
SERVICOS ADMINISTRATIVOS 42 7.4%
 
COMERCIO POR ATACADO 40 7.1%
 
SERVICOS DE EDUCACAO 33 5.8%
 
QUIMICA-PETROQUIMICA 27 4.8%
 
SERVICOS DE SAUDE 25 4.4%
 
TRANSPORTE, ARMAZENAGEM E CORREIO 25 4.4%
 
COMERCIO E REPARACAO DE VEICULOS 21 3.7%
 
Other values (19) 98 17.3%
 
Max length49
Mean length30.04770318
Min length7
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

de_saude_rescencia
Constant

This variable is constant and should be ignored for analysis

Constant valueACIMA DE 1 ANO

de_saude_tributaria
Categorical

Distinct count5
Unique (%)0.9%
Missing (%)0.0%
Missing (n)0
VERDE
376
AZUL
134
LARANJA
 
44
Other values (2)
 
12
ValueCountFrequency (%) 
VERDE 376 66.4%
 
AZUL 134 23.7%
 
LARANJA 44 7.8%
 
VERMELHO 11 1.9%
 
AMARELO 1 0.2%
 
Max length8
Mean length4.980565371
Min length4
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

dt_situacao
Categorical

Distinct count207
Unique (%)36.6%
Missing (%)0.0%
Missing (n)0
2005-11-03
201
2005-08-27
 
36
2005-09-24
 
32
Other values (204)
297
ValueCountFrequency (%) 
2005-11-03 201 35.5%
 
2005-08-27 36 6.4%
 
2005-09-24 32 5.7%
 
1998-07-28 17 3.0%
 
2005-10-07 8 1.4%
 
2005-10-14 6 1.1%
 
2004-12-31 5 0.9%
 
2004-12-24 5 0.9%
 
2005-05-21 4 0.7%
 
2005-01-08 4 0.7%
 
Other values (197) 248 43.8%
 
Max length10
Mean length10
Min length10
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

empsetorcensitariofaixarendapopulacao
Numeric

Distinct count439
Unique (%)77.6%
Missing (%)12.4%
Missing (n)70
Infinite (%)0.0%
Infinite (n)0
Mean1722.204395
Minimum262.9
Maximum8467.07
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum262.9
5-th percentile503.2475
Q1818.405
Median1215.16
Q32257.655
95-th percentile4802.195
Maximum8467.07
Range8204.17
Interquartile range1439.25

Descriptive statistics

Standard deviation1349.288829
Coef of variation0.7834661396
Kurtosis3.935623171
Mean1722.204395
MAD998.7775871
Skewness1.869048904
Sum854213.38
Variance1820580.344
Memory size8.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
1156.95 10 1.8%
 
2799.81 4 0.7%
 
2286.1 3 0.5%
 
984.57 3 0.5%
 
3321.86 3 0.5%
 
2317.14 3 0.5%
 
1333.14 3 0.5%
 
1723.24 3 0.5%
 
5054.1 3 0.5%
 
2679.5 2 0.4%
 
Other values (428) 459 81.1%
 
(Missing) 70 12.4%
 

Minimum 5 values

ValueCountFrequency (%) 
262.9 1 0.2%
 
297.41 1 0.2%
 
304.77 1 0.2%
 
340.39 1 0.2%
 
346.02 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
8467.07 2 0.4%
 
6721.57 1 0.2%
 
6583.62 1 0.2%
 
6527.18 1 0.2%
 
6498.24 1 0.2%
 

faturamento_est_coligados
Numeric

Distinct count239
Unique (%)42.2%
Missing (%)48.2%
Missing (n)273
Infinite (%)0.0%
Infinite (n)0
Mean195488702.7
Minimum123638.3984
Maximum7780735739
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum123638.3984
5-th percentile210000
Q1930000
Median7480123.094
Q345218549.01
95-th percentile485413830.4
Maximum7780735739
Range7780612101
Interquartile range44288549.01

Descriptive statistics

Standard deviation888324928.2
Coef of variation4.544124115
Kurtosis45.40607524
Mean195488702.7
MAD312057824.4
Skewness6.532925766
Sum5.72781899e+10
Variance7.89121178e+17
Memory size8.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
210000 32 5.7%
 
420000 10 1.8%
 
630000 5 0.9%
 
930000 5 0.9%
 
840000 2 0.4%
 
333638.3984 2 0.4%
 
1140000 2 0.4%
 
1350000 2 0.4%
 
123638.3984 2 0.4%
 
1112745.625 2 0.4%
 
Other values (228) 229 40.5%
 
(Missing) 273 48.2%
 

Minimum 5 values

ValueCountFrequency (%) 
123638.3984 2 0.4%
 
154548 1 0.2%
 
164851.2031 1 0.2%
 
185457.5938 1 0.2%
 
210000 32 5.7%
 

Maximum 5 values

ValueCountFrequency (%) 
7780735739 1 0.2%
 
7559949122 1 0.2%
 
5964501821 1 0.2%
 
5223030950 1 0.2%
 
4148370912 1 0.2%
 

faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with faturamento_est_coligados and should be ignored for analysis

Correlation0.967174556

fl_antt
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
False
474
True
 
92
ValueCountFrequency (%) 
False 474 83.7%
 
True 92 16.3%
 

fl_email
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
False
304
True
262
ValueCountFrequency (%) 
False 304 53.7%
 
True 262 46.3%
 

fl_epp
Constant

This variable is constant and should be ignored for analysis

Constant valueFalse

fl_ltda
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
False
562
True
 
4
ValueCountFrequency (%) 
False 562 99.3%
 
True 4 0.7%
 

fl_matriz
Constant

This variable is constant and should be ignored for analysis

Constant valueTrue

fl_me
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
False
564
True
 
2
ValueCountFrequency (%) 
False 564 99.6%
 
True 2 0.4%
 

fl_mei
Constant

This variable is constant and should be ignored for analysis

Constant valueFalse

fl_optante_simei
Constant

This variable is constant and should be ignored for analysis

Constant valueFalse

fl_optante_simples
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
False
539
True
 
27
ValueCountFrequency (%) 
False 539 95.2%
 
True 27 4.8%
 

fl_passivel_iss
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
True
490
False
 
76
ValueCountFrequency (%) 
True 490 86.6%
 
False 76 13.4%
 

fl_rm
Categorical

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
SIM
307
NAO
259
ValueCountFrequency (%) 
SIM 307 54.2%
 
NAO 259 45.8%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

fl_sa
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
False
543
True
 
23
ValueCountFrequency (%) 
False 543 95.9%
 
True 23 4.1%
 

fl_simples_irregular
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
False
565
True
 
1
ValueCountFrequency (%) 
False 565 99.8%
 
True 1 0.2%
 

fl_spa
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
False
539
True
 
27
ValueCountFrequency (%) 
False 539 95.2%
 
True 27 4.8%
 

fl_st_especial
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
False
564
True
 
2
ValueCountFrequency (%) 
False 564 99.6%
 
True 2 0.4%
 

fl_telefone
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
True
307
False
259
ValueCountFrequency (%) 
True 307 54.2%
 
False 259 45.8%
 

fl_veiculo
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
True
490
False
 
76
ValueCountFrequency (%) 
True 490 86.6%
 
False 76 13.4%
 

grau_instrucao_macro_analfabeto
Numeric

Distinct count18
Unique (%)3.2%
Missing (%)79.3%
Missing (n)449
Infinite (%)0.0%
Infinite (n)0
Mean5.128205128
Minimum1
Maximum135
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median2
Q35
95-th percentile11.2
Maximum135
Range134
Interquartile range4

Descriptive statistics

Standard deviation14.43387924
Coef of variation2.814606453
Kurtosis63.00737557
Mean5.128205128
MAD5.169406092
Skewness7.613012894
Sum600
Variance208.33687
Memory size8.8 KiB
Histogram
Histogram with fixed size bins (bins=18)
ValueCountFrequency (%) 
1 51 9.0%
 
2 20 3.5%
 
3 11 1.9%
 
6 7 1.2%
 
4 5 0.9%
 
10 4 0.7%
 
7 4 0.7%
 
9 3 0.5%
 
5 2 0.4%
 
11 2 0.4%
 
Other values (7) 8 1.4%
 
(Missing) 449 79.3%
 

Minimum 5 values

ValueCountFrequency (%) 
1 51 9.0%
 
2 20 3.5%
 
3 11 1.9%
 
4 5 0.9%
 
5 2 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
135 1 0.2%
 
80 1 0.2%
 
17 1 0.2%
 
14 1 0.2%
 
13 1 0.2%
 

grau_instrucao_macro_desconhecido
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

grau_instrucao_macro_escolaridade_fundamental
Numeric

Distinct count157
Unique (%)27.7%
Missing (%)8.5%
Missing (n)48
Infinite (%)0.0%
Infinite (n)0
Mean73.21235521
Minimum1
Maximum3378
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile2
Q18
Median24.5
Q364.75
95-th percentile268.6
Maximum3378
Range3377
Interquartile range56.75

Descriptive statistics

Standard deviation205.9200829
Coef of variation2.812641149
Kurtosis143.0215049
Mean73.21235521
MAD80.38611529
Skewness10.29942894
Sum37924
Variance42403.08054
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
1 25 4.4%
 
2 24 4.2%
 
4 22 3.9%
 
3 18 3.2%
 
7 17 3.0%
 
10 13 2.3%
 
6 13 2.3%
 
13 13 2.3%
 
18 12 2.1%
 
9 12 2.1%
 
Other values (146) 349 61.7%
 
(Missing) 48 8.5%
 

Minimum 5 values

ValueCountFrequency (%) 
1 25 4.4%
 
2 24 4.2%
 
3 18 3.2%
 
4 22 3.9%
 
5 8 1.4%
 

Maximum 5 values

ValueCountFrequency (%) 
3378 1 0.2%
 
1943 1 0.2%
 
1041 1 0.2%
 
971 1 0.2%
 
794 1 0.2%
 

grau_instrucao_macro_escolaridade_media
Numeric

Distinct count268
Unique (%)47.3%
Missing (%)0.5%
Missing (n)3
Infinite (%)0.0%
Infinite (n)0
Mean189.2468917
Minimum1
Maximum10413
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile18
Q148
Median78
Q3167.5
95-th percentile547.4
Maximum10413
Range10412
Interquartile range119.5

Descriptive statistics

Standard deviation538.648131
Coef of variation2.846272012
Kurtosis235.7275091
Mean189.2468917
MAD184.5049768
Skewness13.38892342
Sum106546
Variance290141.809
Memory size8.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
73 8 1.4%
 
51 8 1.4%
 
38 8 1.4%
 
70 7 1.2%
 
55 7 1.2%
 
53 7 1.2%
 
72 7 1.2%
 
59 7 1.2%
 
43 7 1.2%
 
30 6 1.1%
 
Other values (257) 491 86.7%
 

Minimum 5 values

ValueCountFrequency (%) 
1 1 0.2%
 
3 1 0.2%
 
4 1 0.2%
 
5 2 0.4%
 
6 2 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
10413 1 0.2%
 
3256 1 0.2%
 
3054 1 0.2%
 
2447 1 0.2%
 
2387 1 0.2%
 

grau_instrucao_macro_escolaridade_superior
Numeric

Distinct count188
Unique (%)33.2%
Missing (%)3.0%
Missing (n)17
Infinite (%)0.0%
Infinite (n)0
Mean115.9817851
Minimum1
Maximum4791
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile2
Q18
Median25
Q385
95-th percentile381.6
Maximum4791
Range4790
Interquartile range77

Descriptive statistics

Standard deviation374.6644723
Coef of variation3.230373391
Kurtosis79.78053406
Mean115.9817851
MAD140.5424202
Skewness8.107463407
Sum63674
Variance140373.4668
Memory size8.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
3 30 5.3%
 
2 27 4.8%
 
4 18 3.2%
 
7 17 3.0%
 
5 16 2.8%
 
1 15 2.7%
 
6 14 2.5%
 
10 12 2.1%
 
8 12 2.1%
 
12 11 1.9%
 
Other values (177) 377 66.6%
 
(Missing) 17 3.0%
 

Minimum 5 values

ValueCountFrequency (%) 
1 15 2.7%
 
2 27 4.8%
 
3 30 5.3%
 
4 18 3.2%
 
5 16 2.8%
 

Maximum 5 values

ValueCountFrequency (%) 
4791 1 0.2%
 
4152 1 0.2%
 
2807 1 0.2%
 
2652 1 0.2%
 
2161 1 0.2%
 

id
Categorical, Unique

First 5 values
00990ce9e5ed028c985c70d79caf6bfafec0611deacee6...
01a586fca9efeab9f83ccab019962b0887882fac2625fe...
01ecafa00e8e543ab9fe828672c4c1ff5737610514c0b8...
021ac088e5a7462494d919e7b7b0781e9ae5aa8b6a370b...
021d2faf177f995a2011eb905d14777ec5091106b121a4...
Last 5 values
ff4ce2406e71e486b19e95137147273a32f8dd218a78d7...
ff6f9b8c9ff446342c06e6a858e9589e708412ffd409b3...
ff7a936c109aa9eacb07b9a4817b6358b41221644c2bce...
ffa23f42a6e5d386c5af84a747bdc32d43e632b6ffaaac...
ffeeb8d2494392dc868d636243d3f97ab607b9ca6e200a...

First 5 values

ValueCountFrequency (%) 
00990ce9e5ed028c985c70d79caf6bfafec0611deacee65001879ae201e5d36b 1 0.2%
 
01a586fca9efeab9f83ccab019962b0887882fac2625fe8363da97276c25e0f2 1 0.2%
 
01ecafa00e8e543ab9fe828672c4c1ff5737610514c0b8e33b0a49a83f72238c 1 0.2%
 
021ac088e5a7462494d919e7b7b0781e9ae5aa8b6a370b2d65c44345f0ecc857 1 0.2%
 
021d2faf177f995a2011eb905d14777ec5091106b121a4bdb7f4a6eac5fd978f 1 0.2%
 

Last 5 values

ValueCountFrequency (%) 
ffeeb8d2494392dc868d636243d3f97ab607b9ca6e200aa897cbd7cb320cf8a2 1 0.2%
 
ffa23f42a6e5d386c5af84a747bdc32d43e632b6ffaaac3ac349c280cae803fd 1 0.2%
 
ff7a936c109aa9eacb07b9a4817b6358b41221644c2bce37ba76d16469a8982a 1 0.2%
 
ff6f9b8c9ff446342c06e6a858e9589e708412ffd409b3ff71d663ecf8761bc6 1 0.2%
 
ff4ce2406e71e486b19e95137147273a32f8dd218a78d7a5ea0952f135258ef9 1 0.2%
 

idade_acima_de_58
Numeric

Distinct count100
Unique (%)17.7%
Missing (%)10.8%
Missing (n)61
Infinite (%)0.0%
Infinite (n)0
Mean40.74851485
Minimum1
Maximum3663
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q13
Median8
Q323
95-th percentile117
Maximum3663
Range3662
Interquartile range20

Descriptive statistics

Standard deviation203.0101211
Coef of variation4.982025033
Kurtosis218.0056736
Mean40.74851485
MAD52.51729046
Skewness13.58709941
Sum20578
Variance41213.10925
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
2 55 9.7%
 
1 55 9.7%
 
5 38 6.7%
 
3 32 5.7%
 
4 31 5.5%
 
7 21 3.7%
 
6 20 3.5%
 
8 17 3.0%
 
9 14 2.5%
 
11 13 2.3%
 
Other values (89) 209 36.9%
 
(Missing) 61 10.8%
 

Minimum 5 values

ValueCountFrequency (%) 
1 55 9.7%
 
2 55 9.7%
 
3 32 5.7%
 
4 31 5.5%
 
5 38 6.7%
 

Maximum 5 values

ValueCountFrequency (%) 
3663 1 0.2%
 
1844 1 0.2%
 
1401 1 0.2%
 
906 1 0.2%
 
674 1 0.2%
 

idade_ate_18
Numeric

Distinct count15
Unique (%)2.7%
Missing (%)62.0%
Missing (n)351
Infinite (%)0.0%
Infinite (n)0
Mean3.455813953
Minimum1
Maximum83
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median2
Q33.5
95-th percentile7
Maximum83
Range82
Interquartile range2.5

Descriptive statistics

Standard deviation7.161465623
Coef of variation2.072294898
Kurtosis85.44945354
Mean3.455813953
MAD2.608242293
Skewness8.667064492
Sum743
Variance51.28658987
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=15)
ValueCountFrequency (%) 
1 78 13.8%
 
2 51 9.0%
 
3 32 5.7%
 
4 14 2.5%
 
6 13 2.3%
 
5 11 1.9%
 
7 6 1.1%
 
8 3 0.5%
 
9 2 0.4%
 
10 1 0.2%
 
Other values (4) 4 0.7%
 
(Missing) 351 62.0%
 

Minimum 5 values

ValueCountFrequency (%) 
1 78 13.8%
 
2 51 9.0%
 
3 32 5.7%
 
4 14 2.5%
 
5 11 1.9%
 

Maximum 5 values

ValueCountFrequency (%) 
83 1 0.2%
 
56 1 0.2%
 
33 1 0.2%
 
12 1 0.2%
 
10 1 0.2%
 

idade_de_19_a_23
Numeric

Distinct count72
Unique (%)12.7%
Missing (%)16.6%
Missing (n)94
Infinite (%)0.0%
Infinite (n)0
Mean18.30720339
Minimum1
Maximum643
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q13
Median9
Q316.25
95-th percentile56.45
Maximum643
Range642
Interquartile range13.25

Descriptive statistics

Standard deviation45.50048308
Coef of variation2.485386878
Kurtosis91.84566443
Mean18.30720339
MAD17.73490017
Skewness8.433041752
Sum8641
Variance2070.293961
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
1 52 9.2%
 
2 38 6.7%
 
3 35 6.2%
 
4 25 4.4%
 
5 25 4.4%
 
8 24 4.2%
 
9 21 3.7%
 
11 20 3.5%
 
6 20 3.5%
 
10 17 3.0%
 
Other values (61) 195 34.5%
 
(Missing) 94 16.6%
 

Minimum 5 values

ValueCountFrequency (%) 
1 52 9.2%
 
2 38 6.7%
 
3 35 6.2%
 
4 25 4.4%
 
5 25 4.4%
 

Maximum 5 values

ValueCountFrequency (%) 
643 1 0.2%
 
373 1 0.2%
 
323 1 0.2%
 
286 1 0.2%
 
253 1 0.2%
 

idade_de_24_a_28
Numeric

Distinct count107
Unique (%)18.9%
Missing (%)3.0%
Missing (n)17
Infinite (%)0.0%
Infinite (n)0
Mean33.13661202
Minimum1
Maximum949
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile3
Q19
Median17
Q331
95-th percentile101.8
Maximum949
Range948
Interquartile range22

Descriptive statistics

Standard deviation66.39742589
Coef of variation2.003748176
Kurtosis83.92472733
Mean33.13661202
MAD29.78578041
Skewness7.759961364
Sum18192
Variance4408.618164
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
6 25 4.4%
 
12 22 3.9%
 
9 21 3.7%
 
7 20 3.5%
 
8 20 3.5%
 
15 20 3.5%
 
10 19 3.4%
 
21 19 3.4%
 
11 19 3.4%
 
17 17 3.0%
 
Other values (96) 347 61.3%
 

Minimum 5 values

ValueCountFrequency (%) 
1 11 1.9%
 
2 11 1.9%
 
3 15 2.7%
 
4 16 2.8%
 
5 13 2.3%
 

Maximum 5 values

ValueCountFrequency (%) 
949 1 0.2%
 
631 1 0.2%
 
486 1 0.2%
 
376 1 0.2%
 
359 1 0.2%
 

idade_de_29_a_33
Numeric

Distinct count136
Unique (%)24.0%
Missing (%)0.7%
Missing (n)4
Infinite (%)0.0%
Infinite (n)0
Mean49.6227758
Minimum1
Maximum785
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile7.05
Q114
Median23
Q345
95-th percentile169.8
Maximum785
Range784
Interquartile range31

Descriptive statistics

Standard deviation87.52580499
Coef of variation1.763823236
Kurtosis30.97860562
Mean49.6227758
MAD44.24394321
Skewness5.072267201
Sum27888
Variance7660.766539
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
16 24 4.2%
 
9 22 3.9%
 
12 21 3.7%
 
15 21 3.7%
 
18 20 3.5%
 
13 19 3.4%
 
10 19 3.4%
 
19 17 3.0%
 
26 15 2.7%
 
8 15 2.7%
 
Other values (125) 369 65.2%
 

Minimum 5 values

ValueCountFrequency (%) 
1 1 0.2%
 
2 4 0.7%
 
3 3 0.5%
 
4 5 0.9%
 
5 4 0.7%
 

Maximum 5 values

ValueCountFrequency (%) 
785 1 0.2%
 
749 1 0.2%
 
714 1 0.2%
 
580 1 0.2%
 
559 1 0.2%
 

idade_de_34_a_38
Numeric

Distinct count148
Unique (%)26.1%
Missing (%)0.2%
Missing (n)1
Infinite (%)0.0%
Infinite (n)0
Mean59.07964602
Minimum1
Maximum1884
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile8
Q115
Median25
Q349
95-th percentile178.4
Maximum1884
Range1883
Interquartile range34

Descriptive statistics

Standard deviation128.6450213
Coef of variation2.177484633
Kurtosis87.79843661
Mean59.07964602
MAD56.5372073
Skewness7.961675988
Sum33380
Variance16549.54152
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
16 20 3.5%
 
13 19 3.4%
 
11 19 3.4%
 
21 18 3.2%
 
14 18 3.2%
 
10 17 3.0%
 
20 15 2.7%
 
17 15 2.7%
 
22 14 2.5%
 
12 14 2.5%
 
Other values (137) 396 70.0%
 

Minimum 5 values

ValueCountFrequency (%) 
1 2 0.4%
 
3 5 0.9%
 
4 1 0.2%
 
5 5 0.9%
 
6 8 1.4%
 

Maximum 5 values

ValueCountFrequency (%) 
1884 1 0.2%
 
1047 1 0.2%
 
1027 1 0.2%
 
923 1 0.2%
 
620 1 0.2%
 

idade_de_39_a_43
Highly correlated

This variable is highly correlated with idade_de_34_a_38 and should be ignored for analysis

Correlation0.9590517955

idade_de_44_a_48
Highly correlated

This variable is highly correlated with idade_de_39_a_43 and should be ignored for analysis

Correlation0.9834234363

idade_de_49_a_53
Highly correlated

This variable is highly correlated with idade_de_44_a_48 and should be ignored for analysis

Correlation0.9902727483

idade_de_54_a_58
Highly correlated

This variable is highly correlated with idade_de_49_a_53 and should be ignored for analysis

Correlation0.9851407204

idade_emp_cat
Categorical

Distinct count3
Unique (%)0.5%
Missing (%)0.0%
Missing (n)0
> 20
379
10 a 15
98
15 a 20
89
ValueCountFrequency (%) 
> 20 379 67.0%
 
10 a 15 98 17.3%
 
15 a 20 89 15.7%
 
Max length7
Mean length4.991166078
Min length4
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

idade_empresa_anos
Numeric

Distinct count486
Unique (%)85.9%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean26.98769059
Minimum10.03835616
Maximum55.1260274
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum10.03835616
5-th percentile11.7369863
Q117.83219178
Median23.40273973
Q338.62808219
95-th percentile45.09931507
Maximum55.1260274
Range45.08767123
Interquartile range20.79589041

Descriptive statistics

Standard deviation11.63836045
Coef of variation0.4312469943
Kurtosis-1.042094253
Mean26.98769059
MAD10.01434625
Skewness0.4654955562
Sum15275.03288
Variance135.451434
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[10.03835616 21.81506849 21.85342466 26.79178082 43.76575342 43.85342466 43.85616438 43.88219178 52.20547945 55.1260274 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
21.83561644 16 2.8%
 
43.85479452 14 2.5%
 
43.86575342 10 1.8%
 
21.83287671 7 1.2%
 
43.87671233 6 1.1%
 
43.86849315 5 0.9%
 
21.81643836 3 0.5%
 
43.8 3 0.5%
 
14.95068493 2 0.4%
 
21.87123288 2 0.4%
 
Other values (476) 498 88.0%
 

Minimum 5 values

ValueCountFrequency (%) 
10.03835616 1 0.2%
 
10.06575342 1 0.2%
 
10.28493151 1 0.2%
 
10.32328767 1 0.2%
 
10.36438356 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
55.1260274 1 0.2%
 
52.2739726 1 0.2%
 
52.1369863 1 0.2%
 
52.03561644 1 0.2%
 
51.85205479 1 0.2%
 

idade_maxima_coligadas
Highly correlated

This variable is highly correlated with coligada_mais_antiga_ativa and should be ignored for analysis

Correlation0.9991113517

idade_maxima_socios
Numeric

Distinct count62
Unique (%)11.0%
Missing (%)37.6%
Missing (n)213
Infinite (%)0.0%
Infinite (n)0
Mean57.60906516
Minimum20
Maximum90
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum20
5-th percentile35.6
Q149
Median59
Q366
95-th percentile78
Maximum90
Range70
Interquartile range17

Descriptive statistics

Standard deviation12.81734121
Coef of variation0.2224882695
Kurtosis-0.2484190386
Mean57.60906516
MAD10.33734321
Skewness-0.04847190227
Sum20336
Variance164.2842358
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
59 17 3.0%
 
61 16 2.8%
 
52 14 2.5%
 
57 13 2.3%
 
65 12 2.1%
 
54 12 2.1%
 
64 12 2.1%
 
55 12 2.1%
 
68 11 1.9%
 
66 10 1.8%
 
Other values (51) 224 39.6%
 
(Missing) 213 37.6%
 

Minimum 5 values

ValueCountFrequency (%) 
20 1 0.2%
 
28 1 0.2%
 
29 1 0.2%
 
30 2 0.4%
 
31 3 0.5%
 

Maximum 5 values

ValueCountFrequency (%) 
90 3 0.5%
 
89 1 0.2%
 
86 1 0.2%
 
84 2 0.4%
 
83 2 0.4%
 

idade_media_coligadas
Numeric

Distinct count300
Unique (%)53.0%
Missing (%)47.2%
Missing (n)267
Infinite (%)0.0%
Infinite (n)0
Mean174.3165949
Minimum2.766666667
Maximum615.1833333
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2.766666667
5-th percentile35.37
Q198.14583333
Median156.0611111
Q3234.78
95-th percentile367.6938889
Maximum615.1833333
Range612.4166667
Interquartile range136.6341667

Descriptive statistics

Standard deviation105.3132783
Coef of variation0.6041494694
Kurtosis1.026749977
Mean174.3165949
MAD83.1837836
Skewness0.9241585577
Sum52120.66186
Variance11090.88658
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
194.1666667 1 0.2%
 
128.6866667 1 0.2%
 
191.4714286 1 0.2%
 
75.46666667 1 0.2%
 
188.9979167 1 0.2%
 
71.46190476 1 0.2%
 
161.3666667 1 0.2%
 
442.5415094 1 0.2%
 
42.83333333 1 0.2%
 
73.53333333 1 0.2%
 
Other values (289) 289 51.1%
 
(Missing) 267 47.2%
 

Minimum 5 values

ValueCountFrequency (%) 
2.766666667 1 0.2%
 
5.8 1 0.2%
 
8.933333333 1 0.2%
 
9.466666667 1 0.2%
 
13.65 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
615.1833333 1 0.2%
 
504.6916667 1 0.2%
 
495.95 1 0.2%
 
488.5027778 1 0.2%
 
444.5296296 1 0.2%
 

idade_media_coligadas_ativas
Highly correlated

This variable is highly correlated with idade_media_coligadas and should be ignored for analysis

Correlation0.9994986426

idade_media_coligadas_baixadas
Categorical

Distinct count2
Unique (%)0.4%
Missing (%)99.8%
Missing (n)565
190.9
 
1
(Missing)
565
ValueCountFrequency (%) 
190.9 1 0.2%
 
(Missing) 565 99.8%
 
Max length5
Mean length3.003533569
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

idade_media_socios
Numeric

Distinct count144
Unique (%)25.4%
Missing (%)37.6%
Missing (n)213
Infinite (%)0.0%
Infinite (n)0
Mean51.55665162
Minimum20
Maximum90
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum20
5-th percentile33.5
Q144
Median51.5
Q358.5
95-th percentile69.4
Maximum90
Range70
Interquartile range14.5

Descriptive statistics

Standard deviation11.068034
Coef of variation0.21467713
Kurtosis0.3014027439
Mean51.55665162
MAD8.773253905
Skewness0.2425835015
Sum18199.49802
Variance122.5013767
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
52 11 1.9%
 
47 9 1.6%
 
54 8 1.4%
 
46 8 1.4%
 
43.5 8 1.4%
 
50 8 1.4%
 
59 7 1.2%
 
56.5 7 1.2%
 
56 7 1.2%
 
44 7 1.2%
 
Other values (133) 273 48.2%
 
(Missing) 213 37.6%
 

Minimum 5 values

ValueCountFrequency (%) 
20 1 0.2%
 
27 2 0.4%
 
28 1 0.2%
 
29 1 0.2%
 
29.5 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
90 2 0.4%
 
80.14285714 1 0.2%
 
79 2 0.4%
 
78 1 0.2%
 
76.5 1 0.2%
 

idade_minima_coligadas
Highly correlated

This variable is highly correlated with coligada_mais_nova_ativa and should be ignored for analysis

Correlation0.9996293323

idade_minima_socios
Numeric

Distinct count62
Unique (%)11.0%
Missing (%)37.6%
Missing (n)213
Infinite (%)0.0%
Infinite (n)0
Mean46.02832861
Minimum12
Maximum90
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum12
5-th percentile25.6
Q136
Median46
Q355
95-th percentile68
Maximum90
Range78
Interquartile range19

Descriptive statistics

Standard deviation13.07123367
Coef of variation0.2839823663
Kurtosis-0.07773634152
Mean46.02832861
MAD10.6925824
Skewness0.2743256406
Sum16248
Variance170.8571498
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
54 14 2.5%
 
34 13 2.3%
 
52 13 2.3%
 
36 12 2.1%
 
46 12 2.1%
 
57 12 2.1%
 
41 11 1.9%
 
39 11 1.9%
 
35 11 1.9%
 
50 11 1.9%
 
Other values (51) 233 41.2%
 
(Missing) 213 37.6%
 

Minimum 5 values

ValueCountFrequency (%) 
12 1 0.2%
 
19 1 0.2%
 
20 1 0.2%
 
21 2 0.4%
 
22 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
90 2 0.4%
 
79 1 0.2%
 
78 1 0.2%
 
76 2 0.4%
 
75 1 0.2%
 

max_faturamento_est_coligados
Numeric

Distinct count200
Unique (%)35.3%
Missing (%)48.2%
Missing (n)273
Infinite (%)0.0%
Infinite (n)0
Mean116480360.2
Minimum123638.4
Maximum5962804000
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum123638.4
5-th percentile210000
Q1741830.4
Median5440089.5
Q329982312
95-th percentile230079356
Maximum5962804000
Range5962680362
Interquartile range29240481.6

Descriptive statistics

Standard deviation578199494.3
Coef of variation4.963922615
Kurtosis62.62919643
Mean116480360.2
MAD184061526.6
Skewness7.552615186
Sum3.412874555e+10
Variance3.343146552e+17
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
210000 52 9.2%
 
930000 16 2.8%
 
741830.4 4 0.7%
 
1112745.6 4 0.7%
 
370915.2 3 0.5%
 
2843683.2 2 0.4%
 
989107.2 2 0.4%
 
17412408 2 0.4%
 
1236384 2 0.4%
 
44509824 2 0.4%
 
Other values (189) 204 36.0%
 
(Missing) 273 48.2%
 

Minimum 5 values

ValueCountFrequency (%) 
123638.4 2 0.4%
 
154548 1 0.2%
 
164851.2 1 0.2%
 
185457.6 1 0.2%
 
210000 52 9.2%
 

Maximum 5 values

ValueCountFrequency (%) 
5962804000 1 0.2%
 
5150974000 1 0.2%
 
3774475000 1 0.2%
 
2939676000 1 0.2%
 
2124532000 1 0.2%
 

max_faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with max_faturamento_est_coligados and should be ignored for analysis

Correlation0.9487331088

max_filiais_coligados
Highly correlated

This variable is highly correlated with max_faturamento_est_coligados_gp and should be ignored for analysis

Correlation0.9209527542

max_funcionarios_coligados_gp
Highly correlated

This variable is highly correlated with max_filiais_coligados and should be ignored for analysis

Correlation0.9596800847

max_meses_servicos
Numeric

Distinct count447
Unique (%)79.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean339.4369258
Minimum7.6
Maximum5099.066667
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum7.6
5-th percentile84.825
Q1156.0666667
Median256.0166667
Q3438.9166667
95-th percentile584.425
Maximum5099.066667
Range5091.466667
Interquartile range282.85

Descriptive statistics

Standard deviation519.3340072
Coef of variation1.529986774
Kurtosis72.7271829
Mean339.4369258
MAD200.3572292
Skewness8.19022979
Sum192121.3
Variance269707.811
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 7.6 91.65 95.75 253.3 253.53333333 ... 506.21666667 507.45 594.36666667 722.3 5099.06666667], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
265.6333333 7 1.2%
 
5099.066667 6 1.1%
 
507.2 5 0.9%
 
470.6666667 5 0.9%
 
265.6666667 5 0.9%
 
253.4666667 5 0.9%
 
236.3 4 0.7%
 
545.7 4 0.7%
 
201.8 4 0.7%
 
92.23333333 4 0.7%
 
Other values (437) 517 91.3%
 

Minimum 5 values

ValueCountFrequency (%) 
7.6 1 0.2%
 
21.13333333 1 0.2%
 
24.2 1 0.2%
 
29.6 1 0.2%
 
30.33333333 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
5099.066667 6 1.1%
 
727 1 0.2%
 
717.6 1 0.2%
 
707.3666667 1 0.2%
 
706 1 0.2%
 

max_meses_servicos_all
Numeric

Distinct count383
Unique (%)67.7%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1420.068492
Minimum7.6
Maximum5099.066667
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum7.6
5-th percentile94.125
Q1176.3833333
Median284.05
Q3626.35
95-th percentile5039.333333
Maximum5099.066667
Range5091.466667
Interquartile range449.9666667

Descriptive statistics

Standard deviation2053.583607
Coef of variation1.446115887
Kurtosis-0.5808976304
Mean1420.068492
MAD1758.854233
Skewness1.184433717
Sum803758.7667
Variance4217205.633
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 7.6 91.65 253.3 253.53333333 267.68333333 ... 550.73333333 707.61666667 5008.88333333 5021.06666667 5099.06666667], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
5014.966667 102 18.0%
 
5064.7 18 3.2%
 
5099.066667 6 1.1%
 
5039.333333 5 0.9%
 
265.6333333 4 0.7%
 
5027.166667 4 0.7%
 
201.8 4 0.7%
 
265.6666667 3 0.5%
 
545.7 3 0.5%
 
250.5 3 0.5%
 
Other values (373) 414 73.1%
 

Minimum 5 values

ValueCountFrequency (%) 
7.6 1 0.2%
 
21.2 1 0.2%
 
24.2 1 0.2%
 
29.6 1 0.2%
 
38.43333333 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
5099.066667 6 1.1%
 
5065.733333 2 0.4%
 
5064.7 18 3.2%
 
5039.333333 5 0.9%
 
5027.166667 4 0.7%
 

max_vl_folha_coligados
Numeric

Distinct count188
Unique (%)33.2%
Missing (%)58.7%
Missing (n)332
Infinite (%)0.0%
Infinite (n)0
Mean17944123.51
Minimum61819.2
Maximum354038560
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum61819.2
5-th percentile123638.4
Q1886075.2
Median4049157.65
Q312229898.75
95-th percentile80760604
Maximum354038560
Range353976740.8
Interquartile range11343823.55

Descriptive statistics

Standard deviation45463936.4
Coef of variation2.533639293
Kurtosis25.19332978
Mean17944123.51
MAD22337841.76
Skewness4.705621417
Sum4198924902
Variance2.066969513e+15
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
61819.2 9 1.6%
 
247276.8 5 0.9%
 
556372.8 4 0.7%
 
123638.4 3 0.5%
 
370915.2 3 0.5%
 
144244.8 3 0.5%
 
1256990.4 3 0.5%
 
618192 3 0.5%
 
185457.6 3 0.5%
 
16959068 2 0.4%
 
Other values (177) 196 34.6%
 
(Missing) 332 58.7%
 

Minimum 5 values

ValueCountFrequency (%) 
61819.2 9 1.6%
 
82425.6 1 0.2%
 
103032 1 0.2%
 
123638.4 3 0.5%
 
144244.8 3 0.5%
 

Maximum 5 values

ValueCountFrequency (%) 
354038560 1 0.2%
 
313031800 1 0.2%
 
243979780 1 0.2%
 
207712510 1 0.2%
 
203920930 1 0.2%
 

max_vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with max_faturamento_est_coligados_gp and should be ignored for analysis

Correlation0.932597259

media_faturamento_est_coligados
Numeric

Distinct count237
Unique (%)41.9%
Missing (%)48.2%
Missing (n)273
Infinite (%)0.0%
Infinite (n)0
Mean16856704.32
Minimum123638.3984
Maximum1192900364
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum123638.3984
5-th percentile210000
Q1383186.4062
Median1990485.625
Q37879169.635
95-th percentile42988581.56
Maximum1192900364
Range1192776726
Interquartile range7495983.229

Descriptive statistics

Standard deviation82354549.67
Coef of variation4.885566485
Kurtosis148.7494604
Mean16856704.32
MAD23581862.06
Skewness11.27054204
Sum4939014366
Variance6.782271851e+15
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
210000 49 8.7%
 
930000 5 0.9%
 
123638.3984 2 0.4%
 
570000 2 0.4%
 
166819.1992 2 0.4%
 
450000 2 0.4%
 
1112745.625 2 0.4%
 
31630823.25 1 0.2%
 
290457.5938 1 0.2%
 
3179578.139 1 0.2%
 
Other values (226) 226 39.9%
 
(Missing) 273 48.2%
 

Minimum 5 values

ValueCountFrequency (%) 
123638.3984 2 0.4%
 
154548 1 0.2%
 
164851.2031 1 0.2%
 
166819.1992 2 0.4%
 
181212.7995 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
1192900364 1 0.2%
 
518546364 1 0.2%
 
348202063.3 1 0.2%
 
303995129.8 1 0.2%
 
209998586.7 1 0.2%
 

media_faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with media_faturamento_est_coligados and should be ignored for analysis

Correlation0.9755334699

media_filiais_coligados
Highly correlated

This variable is highly correlated with media_faturamento_est_coligados_gp and should be ignored for analysis

Correlation0.9378844305

media_funcionarios_coligados_gp
Highly correlated

This variable is highly correlated with media_filiais_coligados and should be ignored for analysis

Correlation0.9763654488

media_meses_servicos
Numeric

Distinct count566
Unique (%)100.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean94.1729652
Minimum5.554138702
Maximum459.9690112
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum5.554138702
5-th percentile24.09252205
Q143.72636125
Median69.79553001
Q3146.3689106
95-th percentile211.793001
Maximum459.9690112
Range454.4148725
Interquartile range102.6425493

Descriptive statistics

Standard deviation67.05063737
Coef of variation0.7119945435
Kurtosis2.218526801
Mean94.1729652
MAD54.8986747
Skewness1.281018884
Sum53301.8983
Variance4495.787971
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 5.5541387 23.48033312 57.21315789 81.80277904 200.91285363 247.56763822 459.96901121], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
44.58764045 1 0.2%
 
164.3069182 1 0.2%
 
35.77932761 1 0.2%
 
142.8045161 1 0.2%
 
94.78803419 1 0.2%
 
64.52540984 1 0.2%
 
89.70457516 1 0.2%
 
12.77495495 1 0.2%
 
24.96283525 1 0.2%
 
169.5390071 1 0.2%
 
Other values (556) 556 98.2%
 

Minimum 5 values

ValueCountFrequency (%) 
5.554138702 1 0.2%
 
5.609803922 1 0.2%
 
7.558563536 1 0.2%
 
7.896825397 1 0.2%
 
8.404268293 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
459.9690112 1 0.2%
 
409.2984364 1 0.2%
 
353.9549383 1 0.2%
 
319.0152482 1 0.2%
 
313.4891775 1 0.2%
 

media_meses_servicos_all
Numeric

Distinct count566
Unique (%)100.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean80.26095314
Minimum2.707324365
Maximum944.6335318
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2.707324365
5-th percentile12.32808675
Q124.67910908
Median43.50388572
Q3113.4795707
95-th percentile241.5506979
Maximum944.6335318
Range941.9262074
Interquartile range88.80046167

Descriptive statistics

Standard deviation88.56668495
Coef of variation1.103484091
Kurtosis18.78964654
Mean80.26095314
MAD62.93407977
Skewness3.146309916
Sum45427.69948
Variance7844.057683
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 2.70732436 10.45628531 37.64888255 64.36235372 173.7754826 249.26943319 364.54312211 944.63353181], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
41.33333333 1 0.2%
 
30.59641276 1 0.2%
 
29.74376489 1 0.2%
 
43.36541995 1 0.2%
 
18.28434457 1 0.2%
 
18.23039216 1 0.2%
 
73.27058419 1 0.2%
 
99.27921348 1 0.2%
 
29.12489177 1 0.2%
 
36.63153846 1 0.2%
 
Other values (556) 556 98.2%
 

Minimum 5 values

ValueCountFrequency (%) 
2.707324365 1 0.2%
 
6.980591497 1 0.2%
 
6.994089835 1 0.2%
 
7.183912176 1 0.2%
 
8.117939756 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
944.6335318 1 0.2%
 
533.9229167 1 0.2%
 
519.2097977 1 0.2%
 
452.3344951 1 0.2%
 
430.0752308 1 0.2%
 

media_vl_folha_coligados
Numeric

Distinct count213
Unique (%)37.6%
Missing (%)58.7%
Missing (n)332
Infinite (%)0.0%
Infinite (n)0
Mean7119954.48
Minimum61819.19922
Maximum354038560
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum61819.19922
5-th percentile116426.159
Q1618192
Median2119368.256
Q35396301.107
95-th percentile21134880.23
Maximum354038560
Range353976740.8
Interquartile range4778109.107

Descriptive statistics

Standard deviation26366605.72
Coef of variation3.703198636
Kurtosis132.712718
Mean7119954.48
MAD8293553.4
Skewness10.70481966
Sum1666069348
Variance6.951978973e+14
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
61819.19922 9 1.6%
 
618192 3 0.5%
 
247276.7969 3 0.5%
 
144244.7969 3 0.5%
 
185457.5938 3 0.5%
 
556372.8125 2 0.4%
 
680011.1875 2 0.4%
 
164851.2031 2 0.4%
 
1256990.375 2 0.4%
 
123638.3984 2 0.4%
 
Other values (202) 203 35.9%
 
(Missing) 332 58.7%
 

Minimum 5 values

ValueCountFrequency (%) 
61819.19922 9 1.6%
 
82425.60156 1 0.2%
 
92728.79883 1 0.2%
 
103032 1 0.2%
 
123638.3984 2 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
354038560 1 0.2%
 
129418495 1 0.2%
 
123432336 1 0.2%
 
48631103.2 1 0.2%
 
40187631.59 1 0.2%
 

media_vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with media_faturamento_est_coligados_gp and should be ignored for analysis

Correlation0.9398249993

meses_ultima_contratacaco
Numeric

Distinct count212
Unique (%)37.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean13.00300353
Minimum1.933333333
Maximum405.7333333
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1.933333333
5-th percentile2.033333333
Q12.441666667
Median3.933333333
Q323.95
95-th percentile34.36666667
Maximum405.7333333
Range403.8
Interquartile range21.50833333

Descriptive statistics

Standard deviation21.49180486
Coef of variation1.652833886
Kurtosis197.626451
Mean13.00300353
MAD12.46822722
Skewness11.23277971
Sum7359.7
Variance461.8976763
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 1.93333333 2.28333333 2.31666667 2.91666667 2.96666667 ... 28.31666667 34.3 34.38333333 64.5 405.73333333], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
2.933333333 37 6.5%
 
2.3 32 5.7%
 
23.2 18 3.2%
 
2 16 2.8%
 
2.066666667 16 2.8%
 
2.266666667 16 2.8%
 
2.533333333 13 2.3%
 
3.933333333 12 2.1%
 
2.766666667 12 2.1%
 
2.2 12 2.1%
 
Other values (202) 382 67.5%
 

Minimum 5 values

ValueCountFrequency (%) 
1.933333333 1 0.2%
 
1.966666667 4 0.7%
 
2 16 2.8%
 
2.033333333 12 2.1%
 
2.066666667 16 2.8%
 

Maximum 5 values

ValueCountFrequency (%) 
405.7333333 1 0.2%
 
106.3666667 1 0.2%
 
65.83333333 1 0.2%
 
63.16666667 1 0.2%
 
62.83333333 1 0.2%
 

min_faturamento_est_coligados
Numeric

Distinct count61
Unique (%)10.8%
Missing (%)48.2%
Missing (n)273
Infinite (%)0.0%
Infinite (n)0
Mean1113347.114
Minimum0
Maximum60994944
Zeros (%)0.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile79428.56
Q1210000
Median210000
Q3210000
95-th percentile3884306.4
Maximum60994944
Range60994944
Interquartile range0

Descriptive statistics

Standard deviation4721194.103
Coef of variation4.240541019
Kurtosis99.34185898
Mean1113347.114
MAD1563841.037
Skewness9.100242041
Sum326210704.3
Variance2.228967376e+13
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
210000 173 30.6%
 
123638.4 26 4.6%
 
185457.6 7 1.2%
 
41212.8 6 1.1%
 
930000 6 1.1%
 
206064 4 0.7%
 
154548 3 0.5%
 
82425.6 3 0.5%
 
74933 2 0.4%
 
618192 2 0.4%
 
Other values (50) 61 10.8%
 
(Missing) 273 48.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1 0.2%
 
9141 1 0.2%
 
19079 1 0.2%
 
41212.8 6 1.1%
 
50000 2 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
60994944 1 0.2%
 
33794496 1 0.2%
 
23182200 1 0.2%
 
21327624 1 0.2%
 
20091240 1 0.2%
 

min_faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with min_faturamento_est_coligados and should be ignored for analysis

Correlation0.947631243

min_filiais_coligados
Numeric

Distinct count10
Unique (%)1.8%
Missing (%)73.0%
Missing (n)413
Infinite (%)0.0%
Infinite (n)0
Mean1.718954248
Minimum1
Maximum33
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q31
95-th percentile5
Maximum33
Range32
Interquartile range0

Descriptive statistics

Standard deviation2.857256497
Coef of variation1.662206251
Kurtosis95.77403011
Mean1.718954248
MAD1.118373275
Skewness9.006651728
Sum263
Variance8.163914689
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 119 21.0%
 
2 17 3.0%
 
3 5 0.9%
 
5 3 0.5%
 
4 3 0.5%
 
8 2 0.4%
 
6 2 0.4%
 
7 1 0.2%
 
33 1 0.2%
 
(Missing) 413 73.0%
 

Minimum 5 values

ValueCountFrequency (%) 
1 119 21.0%
 
2 17 3.0%
 
3 5 0.9%
 
4 3 0.5%
 
5 3 0.5%
 

Maximum 5 values

ValueCountFrequency (%) 
33 1 0.2%
 
8 2 0.4%
 
7 1 0.2%
 
6 2 0.4%
 
5 3 0.5%
 

min_funcionarios_coligados_gp
Numeric

Distinct count59
Unique (%)10.4%
Missing (%)55.5%
Missing (n)314
Infinite (%)0.0%
Infinite (n)0
Mean27.28571429
Minimum0
Maximum2112
Zeros (%)16.4%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median1.5
Q310
95-th percentile100.25
Maximum2112
Range2112
Interquartile range10

Descriptive statistics

Standard deviation143.4629126
Coef of variation5.257803079
Kurtosis180.0766697
Mean27.28571429
MAD40.73922902
Skewness12.66960787
Sum6876
Variance20581.60729
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0 93 16.4%
 
1 33 5.8%
 
2 16 2.8%
 
3 14 2.5%
 
4 8 1.4%
 
5 7 1.2%
 
7 6 1.1%
 
10 6 1.1%
 
9 5 0.9%
 
6 5 0.9%
 
Other values (48) 59 10.4%
 
(Missing) 314 55.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 93 16.4%
 
1 33 5.8%
 
2 16 2.8%
 
3 14 2.5%
 
4 8 1.4%
 

Maximum 5 values

ValueCountFrequency (%) 
2112 1 0.2%
 
592 1 0.2%
 
360 1 0.2%
 
257 1 0.2%
 
235 1 0.2%
 

min_meses_servicos
Highly correlated

This variable is highly correlated with meses_ultima_contratacaco and should be ignored for analysis

Correlation0.983480359

min_meses_servicos_all
Numeric

Distinct count152
Unique (%)26.9%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.8437573616
Minimum-12.03333333
Maximum266.1666667
Zeros (%)6.2%
Mini histogram

Quantile statistics

Minimum-12.03333333
5-th percentile-6.1
Q1-0.6333333333
Median-0.2666666667
Q30.4
95-th percentile8.133333333
Maximum266.1666667
Range278.2
Interquartile range1.033333333

Descriptive statistics

Standard deviation12.15219333
Coef of variation14.40247384
Kurtosis403.9277286
Mean0.8437573616
MAD3.024739352
Skewness18.64899626
Sum477.5666667
Variance147.6758027
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[-1.20333333e+01 -1.05000000e+00 -8.16666667e-01 -3.16666667e-01 -5.00000000e-02 ... 2.98333333e+00 3.10000000e+00 1.20666667e+01 3.48666667e+01 2.66166667e+02], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 35 6.2%
 
-0.03333333333 30 5.3%
 
-0.6333333333 24 4.2%
 
-0.5 23 4.1%
 
-0.7 18 3.2%
 
-0.3666666667 16 2.8%
 
-0.4333333333 14 2.5%
 
1 13 2.3%
 
-0.5666666667 13 2.3%
 
-0.3333333333 12 2.1%
 
Other values (142) 368 65.0%
 

Minimum 5 values

ValueCountFrequency (%) 
-12.03333333 1 0.2%
 
-11.9 1 0.2%
 
-11.66666667 1 0.2%
 
-11.2 3 0.5%
 
-11.16666667 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
266.1666667 1 0.2%
 
35.4 1 0.2%
 
34.33333333 1 0.2%
 
27.5 1 0.2%
 
27.26666667 1 0.2%
 

min_vl_folha_coligados
Highly correlated

This variable is highly correlated with media_vl_folha_coligados and should be ignored for analysis

Correlation0.9271743681

min_vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with min_vl_folha_coligados and should be ignored for analysis

Correlation0.9564480986

natureza_juridica_macro
Categorical

Distinct count4
Unique (%)0.7%
Missing (%)0.0%
Missing (n)0
ENTIDADES EMPRESARIAIS
323
OUTROS
152
ADMINISTRACAO PUBLICA
 
56
ValueCountFrequency (%) 
ENTIDADES EMPRESARIAIS 323 57.1%
 
OUTROS 152 26.9%
 
ADMINISTRACAO PUBLICA 56 9.9%
 
ENTIDADES SEM FINS LUCRATIVOS 35 6.2%
 
Max length29
Mean length18.03710247
Min length6
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_divisao
Categorical

Distinct count60
Unique (%)10.6%
Missing (%)0.0%
Missing (n)0
ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL
163
COMERCIO VAREJISTA
 
46
COMERCIO POR ATACADO EXCETO VEICULOS AUTOMOTORES E MOTOCICLETAS
 
40
Other values (57)
317
ValueCountFrequency (%) 
ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL 163 28.8%
 
COMERCIO VAREJISTA 46 8.1%
 
COMERCIO POR ATACADO EXCETO VEICULOS AUTOMOTORES E MOTOCICLETAS 40 7.1%
 
EDUCACAO 33 5.8%
 
CONSTRUCAO DE EDIFICIOS 31 5.5%
 
ATIVIDADES DE ATENCAO A SAUDE HUMANA 22 3.9%
 
SERVICOS PARA EDIFICIOS E ATIVIDADES PAISAGISTICAS 22 3.9%
 
COMERCIO E REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS 21 3.7%
 
TRANSPORTE TERRESTRE 20 3.5%
 
FABRICACAO DE PRODUTOS DE BORRACHA E DE MATERIAL PLASTICO 11 1.9%
 
Other values (50) 157 27.7%
 
Max length120
Mean length41.19257951
Min length8
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_meso_regiao
Categorical

Distinct count19
Unique (%)3.4%
Missing (%)12.4%
Missing (n)70
CENTRO AMAZONENSE
138
NORTE MARANHENSE
66
CENTRO NORTE PIAUIENSE
62
Other values (15)
230
(Missing)
70
ValueCountFrequency (%) 
CENTRO AMAZONENSE 138 24.4%
 
NORTE MARANHENSE 66 11.7%
 
CENTRO NORTE PIAUIENSE 62 11.0%
 
LESTE POTIGUAR 52 9.2%
 
VALE DO ACRE 32 5.7%
 
OESTE POTIGUAR 28 4.9%
 
OESTE MARANHENSE 16 2.8%
 
SUDESTE PIAUIENSE 15 2.7%
 
CENTRO MARANHENSE 14 2.5%
 
SUDOESTE PIAUIENSE 14 2.5%
 
Other values (8) 59 10.4%
 
(Missing) 70 12.4%
 
Max length22
Mean length14.82332155
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_micro_regiao
Categorical

Distinct count61
Unique (%)10.8%
Missing (%)12.4%
Missing (n)70
MANAUS
126
AGLOMERACAO URBANA DE SAO LUIS
58
NATAL
 
48
Other values (57)
264
(Missing)
70
ValueCountFrequency (%) 
MANAUS 126 22.3%
 
AGLOMERACAO URBANA DE SAO LUIS 58 10.2%
 
NATAL 48 8.5%
 
TERESINA 46 8.1%
 
RIO BRANCO 29 5.1%
 
MOSSORO 16 2.8%
 
IMPERATRIZ 12 2.1%
 
ALTO MEDIO CANINDE 8 1.4%
 
MEDIO MEARIM 8 1.4%
 
PICOS 7 1.2%
 
Other values (50) 138 24.4%
 
(Missing) 70 12.4%
 
Max length33
Mean length10.74911661
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_segmento
Categorical

Distinct count19
Unique (%)3.4%
Missing (%)0.0%
Missing (n)0
ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL
163
COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS
107
INDUSTRIAS DE TRANSFORMACAO
64
Other values (16)
232
ValueCountFrequency (%) 
ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL 163 28.8%
 
COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS 107 18.9%
 
INDUSTRIAS DE TRANSFORMACAO 64 11.3%
 
CONSTRUCAO 46 8.1%
 
ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARES 42 7.4%
 
EDUCACAO 33 5.8%
 
SAUDE HUMANA E SERVICOS SOCIAIS 25 4.4%
 
TRANSPORTE ARMAZENAGEM E CORREIO 25 4.4%
 
OUTRAS ATIVIDADES DE SERVICOS 12 2.1%
 
ALOJAMENTO E ALIMENTACAO 11 1.9%
 
Other values (9) 38 6.7%
 
Max length62
Mean length39.79858657
Min length8
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nu_meses_rescencia
Numeric

Distinct count11
Unique (%)1.9%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean24.75265018
Minimum21
Maximum49
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum21
5-th percentile23
Q123
Median23
Q323
95-th percentile48
Maximum49
Range28
Interquartile range0

Descriptive statistics

Standard deviation5.923012123
Coef of variation0.2392879987
Kurtosis11.2304139
Mean24.75265018
MAD2.950767271
Skewness3.589490011
Sum14010
Variance35.08207261
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=11)
Histogram
Histogram with variable size bins (bins=[21. 22.5 23.5 24.5 25.5 26.5 27.5 47.5 48.5 49. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
23 410 72.4%
 
24 64 11.3%
 
48 29 5.1%
 
26 24 4.2%
 
22 18 3.2%
 
27 6 1.1%
 
21 5 0.9%
 
47 4 0.7%
 
25 4 0.7%
 
28 1 0.2%
 

Minimum 5 values

ValueCountFrequency (%) 
21 5 0.9%
 
22 18 3.2%
 
23 410 72.4%
 
24 64 11.3%
 
25 4 0.7%
 

Maximum 5 values

ValueCountFrequency (%) 
49 1 0.2%
 
48 29 5.1%
 
47 4 0.7%
 
28 1 0.2%
 
27 6 1.1%
 

percent_func_genero_fem
Numeric

Distinct count535
Unique (%)94.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean40.56510601
Minimum0
Maximum87.5
Zeros (%)0.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile3.955
Q117.94
Median42.86
Q361.8825
95-th percentile76.4675
Maximum87.5
Range87.5
Interquartile range43.9425

Descriptive statistics

Standard deviation24.41719919
Coef of variation0.6019261772
Kurtosis-1.291856486
Mean40.56510601
MAD21.66851328
Skewness-0.03644073629
Sum22959.85
Variance596.1996162
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 58.07 70.125 87.5 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
50 5 0.9%
 
51.58 3 0.5%
 
72.93 3 0.5%
 
30.26 2 0.4%
 
52.01 2 0.4%
 
51.97 2 0.4%
 
3.95 2 0.4%
 
42.86 2 0.4%
 
69.14 2 0.4%
 
64.88 2 0.4%
 
Other values (525) 541 95.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1 0.2%
 
0.5 1 0.2%
 
0.56 1 0.2%
 
0.68 2 0.4%
 
0.89 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
87.5 1 0.2%
 
87.19 1 0.2%
 
86.9 1 0.2%
 
86.26 1 0.2%
 
86.06 1 0.2%
 

percent_func_genero_masc
Numeric

Distinct count535
Unique (%)94.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean59.434947
Minimum12.5
Maximum100
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum12.5
5-th percentile23.5325
Q138.1175
Median57.14
Q382.06
95-th percentile96.045
Maximum100
Range87.5
Interquartile range43.9425

Descriptive statistics

Standard deviation24.41716734
Coef of variation0.4108217232
Kurtosis-1.291858528
Mean59.434947
MAD21.66846159
Skewness0.03643965312
Sum33640.18
Variance596.1980611
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 12.5 29.875 41.93 100. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
50 5 0.9%
 
48.42 3 0.5%
 
27.07 3 0.5%
 
95.65 2 0.4%
 
30.86 2 0.4%
 
35.71 2 0.4%
 
48.03 2 0.4%
 
35.11 2 0.4%
 
60.29 2 0.4%
 
41.15 2 0.4%
 
Other values (525) 541 95.6%
 

Minimum 5 values

ValueCountFrequency (%) 
12.5 1 0.2%
 
12.81 1 0.2%
 
13.1 1 0.2%
 
13.74 1 0.2%
 
13.94 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
100 1 0.2%
 
99.5 1 0.2%
 
99.44 1 0.2%
 
99.32 2 0.4%
 
99.11 1 0.2%
 

qt_admitidos
Numeric

Distinct count444
Unique (%)78.4%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean961.9805654
Minimum24
Maximum21259
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum24
5-th percentile133.5
Q1257.75
Median435
Q3904.5
95-th percentile3936.75
Maximum21259
Range21235
Interquartile range646.75

Descriptive statistics

Standard deviation1740.207745
Coef of variation1.808984306
Kurtosis42.73777674
Mean961.9805654
MAD873.6061694
Skewness5.465473681
Sum544481
Variance3028322.996
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 24. 144.5 344.5 551.5 1153.5 2012.5 8307.5 21259. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
246 5 0.9%
 
419 4 0.7%
 
210 4 0.7%
 
275 4 0.7%
 
309 3 0.5%
 
311 3 0.5%
 
156 3 0.5%
 
293 3 0.5%
 
501 3 0.5%
 
270 3 0.5%
 
Other values (434) 531 93.8%
 

Minimum 5 values

ValueCountFrequency (%) 
24 1 0.2%
 
33 1 0.2%
 
53 1 0.2%
 
66 1 0.2%
 
76 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
21259 1 0.2%
 
11739 1 0.2%
 
11544 1 0.2%
 
11466 1 0.2%
 
8340 1 0.2%
 

qt_admitidos_12meses
Numeric

Distinct count125
Unique (%)22.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean37.57067138
Minimum0
Maximum1256
Zeros (%)35.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median9
Q335
95-th percentile158.75
Maximum1256
Range1256
Interquartile range35

Descriptive statistics

Standard deviation93.70188722
Coef of variation2.494016843
Kurtosis61.17215632
Mean37.57067138
MAD45.2795078
Skewness6.50108558
Sum21265
Variance8780.043669
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.000e+00 5.000e-01 1.850e+01 3.050e+01 7.700e+01 1.105e+02 2.390e+02 6.080e+02 1.256e+03], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 199 35.2%
 
10 12 2.1%
 
6 12 2.1%
 
14 11 1.9%
 
1 11 1.9%
 
16 11 1.9%
 
4 11 1.9%
 
5 10 1.8%
 
2 10 1.8%
 
7 9 1.6%
 
Other values (115) 270 47.7%
 

Minimum 5 values

ValueCountFrequency (%) 
0 199 35.2%
 
1 11 1.9%
 
2 10 1.8%
 
3 9 1.6%
 
4 11 1.9%
 

Maximum 5 values

ValueCountFrequency (%) 
1256 1 0.2%
 
642 1 0.2%
 
574 1 0.2%
 
554 2 0.4%
 
475 1 0.2%
 

qt_alteracao_socio_180d
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_alteracao_socio_365d
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_alteracao_socio_90d
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_alteracao_socio_total
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_art
Numeric

Distinct count48
Unique (%)8.5%
Missing (%)53.7%
Missing (n)304
Infinite (%)0.0%
Infinite (n)0
Mean11.16030534
Minimum1
Maximum426
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median3
Q39
95-th percentile43
Maximum426
Range425
Interquartile range8

Descriptive statistics

Standard deviation31.22304307
Coef of variation2.797687169
Kurtosis121.191604
Mean11.16030534
MAD12.56995513
Skewness9.721491341
Sum2924
Variance974.8784183
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=48)
ValueCountFrequency (%) 
1 68 12.0%
 
2 42 7.4%
 
3 30 5.3%
 
4 18 3.2%
 
6 13 2.3%
 
5 12 2.1%
 
14 6 1.1%
 
8 6 1.1%
 
11 6 1.1%
 
10 6 1.1%
 
Other values (37) 55 9.7%
 
(Missing) 304 53.7%
 

Minimum 5 values

ValueCountFrequency (%) 
1 68 12.0%
 
2 42 7.4%
 
3 30 5.3%
 
4 18 3.2%
 
5 12 2.1%
 

Maximum 5 values

ValueCountFrequency (%) 
426 1 0.2%
 
126 1 0.2%
 
118 1 0.2%
 
103 1 0.2%
 
98 1 0.2%
 

qt_coligadas
Numeric

Distinct count32
Unique (%)5.7%
Missing (%)47.2%
Missing (n)267
Infinite (%)0.0%
Infinite (n)0
Mean7.130434783
Minimum1
Maximum296
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q12
Median3
Q37
95-th percentile21.3
Maximum296
Range295
Interquartile range5

Descriptive statistics

Standard deviation18.99857934
Coef of variation2.664434907
Kurtosis180.9050457
Mean7.130434783
MAD6.650574378
Skewness12.23822154
Sum2132
Variance360.9460169
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=32)
ValueCountFrequency (%) 
1 71 12.5%
 
2 46 8.1%
 
3 40 7.1%
 
4 32 5.7%
 
5 19 3.4%
 
6 14 2.5%
 
9 11 1.9%
 
7 10 1.8%
 
8 8 1.4%
 
10 8 1.4%
 
Other values (21) 40 7.1%
 
(Missing) 267 47.2%
 

Minimum 5 values

ValueCountFrequency (%) 
1 71 12.5%
 
2 46 8.1%
 
3 40 7.1%
 
4 32 5.7%
 
5 19 3.4%
 

Maximum 5 values

ValueCountFrequency (%) 
296 1 0.2%
 
68 1 0.2%
 
57 1 0.2%
 
53 2 0.4%
 
48 1 0.2%
 

qt_coligados
Highly correlated

This variable is highly correlated with qt_coligadas and should be ignored for analysis

Correlation0.9999953678

qt_coligados_agropecuaria
Numeric

Distinct count7
Unique (%)1.2%
Missing (%)47.2%
Missing (n)267
Infinite (%)0.0%
Infinite (n)0
Mean0.2240802676
Minimum0
Maximum9
Zeros (%)46.8%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum9
Range9
Interquartile range0

Descriptive statistics

Standard deviation0.901130204
Coef of variation4.021461657
Kurtosis61.0040382
Mean0.2240802676
MAD0.3971991365
Skewness7.021895251
Sum67
Variance0.8120356445
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%) 
0 265 46.8%
 
1 20 3.5%
 
2 8 1.4%
 
3 3 0.5%
 
9 2 0.4%
 
4 1 0.2%
 
(Missing) 267 47.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 265 46.8%
 
1 20 3.5%
 
2 8 1.4%
 
3 3 0.5%
 
4 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
9 2 0.4%
 
4 1 0.2%
 
3 3 0.5%
 
2 8 1.4%
 
1 20 3.5%
 

qt_coligados_atividade_alto
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)47.2%
Missing (n)267
0
299
(Missing)
267
ValueCountFrequency (%) 
0 299 52.8%
 
(Missing) 267 47.2%
 

qt_coligados_atividade_baixo
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)47.2%
Missing (n)267
0
299
(Missing)
267
ValueCountFrequency (%) 
0 299 52.8%
 
(Missing) 267 47.2%
 

qt_coligados_atividade_inativo
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)47.2%
Missing (n)267
0
299
(Missing)
267
ValueCountFrequency (%) 
0 299 52.8%
 
(Missing) 267 47.2%
 

qt_coligados_atividade_medio
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)47.2%
Missing (n)267
0
299
(Missing)
267
ValueCountFrequency (%) 
0 299 52.8%
 
(Missing) 267 47.2%
 

qt_coligados_atividade_mt_baixo
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)47.2%
Missing (n)267
0
299
(Missing)
267
ValueCountFrequency (%) 
0 299 52.8%
 
(Missing) 267 47.2%
 

qt_coligados_ativo
Highly correlated

This variable is highly correlated with qt_coligados and should be ignored for analysis

Correlation0.9998350326

qt_coligados_baixada
Boolean

Distinct count3
Unique (%)0.5%
Missing (%)47.2%
Missing (n)267
0
298
1
 
1
(Missing)
267
ValueCountFrequency (%) 
0 298 52.7%
 
1 1 0.2%
 
(Missing) 267 47.2%
 

qt_coligados_ccivil
Numeric

Distinct count12
Unique (%)2.1%
Missing (%)47.2%
Missing (n)267
Infinite (%)0.0%
Infinite (n)0
Mean1.43812709
Minimum0
Maximum270
Zeros (%)38.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q31
95-th percentile3
Maximum270
Range270
Interquartile range1

Descriptive statistics

Standard deviation15.65350545
Coef of variation10.88464681
Kurtosis293.6318306
Mean1.43812709
MAD2.256976991
Skewness17.06352616
Sum430
Variance245.0322327
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=12)
ValueCountFrequency (%) 
0 220 38.9%
 
1 48 8.5%
 
2 15 2.7%
 
3 8 1.4%
 
4 2 0.4%
 
270 1 0.2%
 
7 1 0.2%
 
8 1 0.2%
 
12 1 0.2%
 
13 1 0.2%
 
(Missing) 267 47.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 220 38.9%
 
1 48 8.5%
 
2 15 2.7%
 
3 8 1.4%
 
4 2 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
270 1 0.2%
 
13 1 0.2%
 
12 1 0.2%
 
10 1 0.2%
 
8 1 0.2%
 

qt_coligados_centro
Numeric

Distinct count9
Unique (%)1.6%
Missing (%)47.2%
Missing (n)267
Infinite (%)0.0%
Infinite (n)0
Mean0.2040133779
Minimum0
Maximum13
Zeros (%)48.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum13
Range13
Interquartile range0

Descriptive statistics

Standard deviation1.050016273
Coef of variation5.146801078
Kurtosis89.79445972
Mean0.2040133779
MAD0.3711815304
Skewness8.723491994
Sum61
Variance1.102534174
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%) 
0 272 48.1%
 
1 18 3.2%
 
2 4 0.7%
 
8 1 0.2%
 
3 1 0.2%
 
4 1 0.2%
 
13 1 0.2%
 
7 1 0.2%
 
(Missing) 267 47.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 272 48.1%
 
1 18 3.2%
 
2 4 0.7%
 
3 1 0.2%
 
4 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
13 1 0.2%
 
8 1 0.2%
 
7 1 0.2%
 
4 1 0.2%
 
3 1 0.2%
 

qt_coligados_comercio
Numeric

Distinct count15
Unique (%)2.7%
Missing (%)47.2%
Missing (n)267
Infinite (%)0.0%
Infinite (n)0
Mean1.408026756
Minimum0
Maximum25
Zeros (%)26.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q32
95-th percentile6
Maximum25
Range25
Interquartile range2

Descriptive statistics

Standard deviation2.783111059
Coef of variation1.976603816
Kurtosis27.48864654
Mean1.408026756
MAD1.608975291
Skewness4.510570479
Sum421
Variance7.745707167
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=15)
ValueCountFrequency (%) 
0 152 26.9%
 
1 65 11.5%
 
2 28 4.9%
 
3 24 4.2%
 
4 10 1.8%
 
6 5 0.9%
 
8 4 0.7%
 
5 4 0.7%
 
14 2 0.4%
 
15 1 0.2%
 
Other values (4) 4 0.7%
 
(Missing) 267 47.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 152 26.9%
 
1 65 11.5%
 
2 28 4.9%
 
3 24 4.2%
 
4 10 1.8%
 

Maximum 5 values

ValueCountFrequency (%) 
25 1 0.2%
 
20 1 0.2%
 
15 1 0.2%
 
14 2 0.4%
 
11 1 0.2%
 

qt_coligados_epp
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)47.2%
Missing (n)267
0
299
(Missing)
267
ValueCountFrequency (%) 
0 299 52.8%
 
(Missing) 267 47.2%
 

qt_coligados_exterior
Categorical

Distinct count4
Unique (%)0.7%
Missing (%)47.2%
Missing (n)267
0
291
1
 
5
2
 
3
(Missing)
267
ValueCountFrequency (%) 
0 291 51.4%
 
1 5 0.9%
 
2 3 0.5%
 
(Missing) 267 47.2%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

qt_coligados_inapta
Categorical

Distinct count4
Unique (%)0.7%
Missing (%)47.2%
Missing (n)267
0
290
1
 
8
2
 
1
(Missing)
267
ValueCountFrequency (%) 
0 290 51.2%
 
1 8 1.4%
 
2 1 0.2%
 
(Missing) 267 47.2%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

qt_coligados_industria
Numeric

Distinct count11
Unique (%)1.9%
Missing (%)47.2%
Missing (n)267
Infinite (%)0.0%
Infinite (n)0
Mean0.8227424749
Minimum0
Maximum48
Zeros (%)37.3%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q31
95-th percentile3
Maximum48
Range48
Interquartile range1

Descriptive statistics

Standard deviation3.436678078
Coef of variation4.177100591
Kurtosis127.1861148
Mean0.8227424749
MAD1.161195065
Skewness10.28996382
Sum246
Variance11.81075621
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%) 
0 211 37.3%
 
1 54 9.5%
 
2 15 2.7%
 
3 9 1.6%
 
4 3 0.5%
 
6 2 0.4%
 
21 2 0.4%
 
10 1 0.2%
 
48 1 0.2%
 
11 1 0.2%
 
(Missing) 267 47.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 211 37.3%
 
1 54 9.5%
 
2 15 2.7%
 
3 9 1.6%
 
4 3 0.5%
 

Maximum 5 values

ValueCountFrequency (%) 
48 1 0.2%
 
21 2 0.4%
 
11 1 0.2%
 
10 1 0.2%
 
6 2 0.4%
 

qt_coligados_ltda
Numeric

Distinct count6
Unique (%)1.1%
Missing (%)47.2%
Missing (n)267
Infinite (%)0.0%
Infinite (n)0
Mean0.08695652174
Minimum0
Maximum8
Zeros (%)50.5%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum8
Range8
Interquartile range0

Descriptive statistics

Standard deviation0.6123426532
Coef of variation7.041940512
Kurtosis122.7190228
Mean0.08695652174
MAD0.1663516068
Skewness10.544464
Sum26
Variance0.3749635249
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%) 
0 286 50.5%
 
1 10 1.8%
 
2 1 0.2%
 
8 1 0.2%
 
6 1 0.2%
 
(Missing) 267 47.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 286 50.5%
 
1 10 1.8%
 
2 1 0.2%
 
6 1 0.2%
 
8 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
8 1 0.2%
 
6 1 0.2%
 
2 1 0.2%
 
1 10 1.8%
 
0 286 50.5%
 

qt_coligados_matriz
Highly correlated

This variable is highly correlated with qt_coligados_ativo and should be ignored for analysis

Correlation0.9990425998

qt_coligados_me
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)47.2%
Missing (n)267
0
299
(Missing)
267
ValueCountFrequency (%) 
0 299 52.8%
 
(Missing) 267 47.2%
 

qt_coligados_mei
Boolean

Distinct count3
Unique (%)0.5%
Missing (%)47.2%
Missing (n)267
0
297
1
 
2
(Missing)
267
ValueCountFrequency (%) 
0 297 52.5%
 
1 2 0.4%
 
(Missing) 267 47.2%
 

qt_coligados_nordeste
Numeric

Distinct count23
Unique (%)4.1%
Missing (%)47.2%
Missing (n)267
Infinite (%)0.0%
Infinite (n)0
Mean2.83277592
Minimum0
Maximum41
Zeros (%)24.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median1
Q34
95-th percentile13
Maximum41
Range41
Interquartile range4

Descriptive statistics

Standard deviation5.373199338
Coef of variation1.896796461
Kurtosis19.60803458
Mean2.83277592
MAD3.283520319
Skewness3.821389583
Sum847
Variance28.87127113
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=23)
ValueCountFrequency (%) 
0 141 24.9%
 
1 39 6.9%
 
2 24 4.2%
 
4 21 3.7%
 
3 19 3.4%
 
6 10 1.8%
 
5 8 1.4%
 
9 8 1.4%
 
10 5 0.9%
 
7 3 0.5%
 
Other values (12) 21 3.7%
 
(Missing) 267 47.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 141 24.9%
 
1 39 6.9%
 
2 24 4.2%
 
3 19 3.4%
 
4 21 3.7%
 

Maximum 5 values

ValueCountFrequency (%) 
41 2 0.4%
 
28 1 0.2%
 
25 2 0.4%
 
21 1 0.2%
 
17 2 0.4%
 

qt_coligados_norte
Numeric

Distinct count20
Unique (%)3.5%
Missing (%)47.2%
Missing (n)267
Infinite (%)0.0%
Infinite (n)0
Mean1.939799331
Minimum0
Maximum52
Zeros (%)28.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q32
95-th percentile9
Maximum52
Range52
Interquartile range2

Descriptive statistics

Standard deviation4.656998914
Coef of variation2.400763233
Kurtosis51.95621186
Mean1.939799331
MAD2.402523462
Skewness6.071461662
Sum580
Variance21.68763889
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=20)
ValueCountFrequency (%) 
0 159 28.1%
 
1 54 9.5%
 
2 22 3.9%
 
3 18 3.2%
 
4 11 1.9%
 
5 8 1.4%
 
6 4 0.7%
 
7 4 0.7%
 
9 4 0.7%
 
14 3 0.5%
 
Other values (9) 12 2.1%
 
(Missing) 267 47.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 159 28.1%
 
1 54 9.5%
 
2 22 3.9%
 
3 18 3.2%
 
4 11 1.9%
 

Maximum 5 values

ValueCountFrequency (%) 
52 1 0.2%
 
32 1 0.2%
 
23 1 0.2%
 
19 1 0.2%
 
17 1 0.2%
 

qt_coligados_nula
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)47.2%
Missing (n)267
0
299
(Missing)
267
ValueCountFrequency (%) 
0 299 52.8%
 
(Missing) 267 47.2%
 

qt_coligados_sa
Highly correlated

This variable is highly correlated with qt_coligados_industria and should be ignored for analysis

Correlation0.9295712651

qt_coligados_serviço
Numeric

Distinct count26
Unique (%)4.6%
Missing (%)47.2%
Missing (n)267
Infinite (%)0.0%
Infinite (n)0
Mean3.244147157
Minimum0
Maximum51
Zeros (%)10.8%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q11
Median1
Q33
95-th percentile12
Maximum51
Range51
Interquartile range2

Descriptive statistics

Standard deviation5.624484244
Coef of variation1.733732772
Kurtosis25.50256666
Mean3.244147157
MAD3.160009396
Skewness4.370971037
Sum970
Variance31.63482301
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=26)
ValueCountFrequency (%) 
1 93 16.4%
 
0 61 10.8%
 
2 48 8.5%
 
3 25 4.4%
 
4 19 3.4%
 
7 14 2.5%
 
12 6 1.1%
 
6 6 1.1%
 
5 6 1.1%
 
8 4 0.7%
 
Other values (15) 17 3.0%
 
(Missing) 267 47.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 61 10.8%
 
1 93 16.4%
 
2 48 8.5%
 
3 25 4.4%
 
4 19 3.4%
 

Maximum 5 values

ValueCountFrequency (%) 
51 1 0.2%
 
37 1 0.2%
 
31 1 0.2%
 
30 1 0.2%
 
25 1 0.2%
 

qt_coligados_sudeste
Highly correlated

This variable is highly correlated with qt_coligados_matriz and should be ignored for analysis

Correlation0.9286701513

qt_coligados_sul
Numeric

Distinct count6
Unique (%)1.1%
Missing (%)47.2%
Missing (n)267
Infinite (%)0.0%
Infinite (n)0
Mean0.110367893
Minimum0
Maximum16
Zeros (%)50.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum16
Range16
Interquartile range0

Descriptive statistics

Standard deviation1.00561821
Coef of variation9.111510451
Kurtosis214.4875524
Mean0.110367893
MAD0.2118768246
Skewness14.04811367
Sum33
Variance1.011267985
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%) 
0 287 50.7%
 
1 9 1.6%
 
2 1 0.2%
 
6 1 0.2%
 
16 1 0.2%
 
(Missing) 267 47.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 287 50.7%
 
1 9 1.6%
 
2 1 0.2%
 
6 1 0.2%
 
16 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
16 1 0.2%
 
6 1 0.2%
 
2 1 0.2%
 
1 9 1.6%
 
0 287 50.7%
 

qt_coligados_suspensa
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)47.2%
Missing (n)267
0
299
(Missing)
267
ValueCountFrequency (%) 
0 299 52.8%
 
(Missing) 267 47.2%
 

qt_desligados
Numeric

Distinct count414
Unique (%)73.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean591.6872792
Minimum7
Maximum11079
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum7
5-th percentile28.5
Q1120
Median238
Q3544.25
95-th percentile2180
Maximum11079
Range11072
Interquartile range424.25

Descriptive statistics

Standard deviation1141.405872
Coef of variation1.929069481
Kurtosis30.347243
Mean591.6872792
MAD585.0575235
Skewness4.917601648
Sum334895
Variance1302807.366
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[7.0000e+00 2.6900e+02 5.4350e+02 9.1750e+02 1.8270e+03 4.3580e+03 1.1079e+04], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
199 5 0.9%
 
124 5 0.9%
 
214 4 0.7%
 
378 4 0.7%
 
221 4 0.7%
 
153 4 0.7%
 
9 3 0.5%
 
89 3 0.5%
 
52 3 0.5%
 
106 3 0.5%
 
Other values (404) 528 93.3%
 

Minimum 5 values

ValueCountFrequency (%) 
7 1 0.2%
 
8 3 0.5%
 
9 3 0.5%
 
10 1 0.2%
 
11 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
11079 1 0.2%
 
9979 1 0.2%
 
7843 1 0.2%
 
7233 1 0.2%
 
6802 1 0.2%
 

qt_desligados_12meses
Numeric

Distinct count111
Unique (%)19.6%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean31.65371025
Minimum0
Maximum1041
Zeros (%)33.0%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median9
Q329
95-th percentile119.5
Maximum1041
Range1041
Interquartile range29

Descriptive statistics

Standard deviation78.75039685
Coef of variation2.487872551
Kurtosis58.53585108
Mean31.65371025
MAD37.43360511
Skewness6.391903299
Sum17916
Variance6201.625004
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.000e+00 5.000e-01 2.250e+01 5.450e+01 9.400e+01 1.565e+02 5.185e+02 1.041e+03], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 187 33.0%
 
10 16 2.8%
 
7 15 2.7%
 
1 13 2.3%
 
4 11 1.9%
 
5 11 1.9%
 
6 11 1.9%
 
15 11 1.9%
 
12 11 1.9%
 
18 11 1.9%
 
Other values (101) 269 47.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 187 33.0%
 
1 13 2.3%
 
2 10 1.8%
 
3 9 1.6%
 
4 11 1.9%
 

Maximum 5 values

ValueCountFrequency (%) 
1041 1 0.2%
 
557 1 0.2%
 
480 1 0.2%
 
460 1 0.2%
 
443 1 0.2%
 

qt_ex_funcionarios
Highly correlated

This variable is highly correlated with qt_desligados and should be ignored for analysis

Correlation0.9999984378

qt_filiais
Numeric

Distinct count35
Unique (%)6.2%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean3.434628975
Minimum0
Maximum172
Zeros (%)47.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median1
Q32
95-th percentile13
Maximum172
Range172
Interquartile range2

Descriptive statistics

Standard deviation11.80363535
Coef of variation3.436655149
Kurtosis106.4926006
Mean3.434628975
MAD4.498907465
Skewness9.209833568
Sum1944
Variance139.3258076
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=35)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 3.5 6.5 10.5 16.5 56. 172. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 270 47.7%
 
1 108 19.1%
 
2 49 8.7%
 
3 29 5.1%
 
4 18 3.2%
 
6 18 3.2%
 
5 10 1.8%
 
7 9 1.6%
 
10 8 1.4%
 
8 6 1.1%
 
Other values (25) 41 7.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 270 47.7%
 
1 108 19.1%
 
2 49 8.7%
 
3 29 5.1%
 
4 18 3.2%
 

Maximum 5 values

ValueCountFrequency (%) 
172 1 0.2%
 
121 1 0.2%
 
116 1 0.2%
 
61 1 0.2%
 
51 1 0.2%
 

qt_funcionarios
Highly correlated

This variable is highly correlated with idade_de_54_a_58 and should be ignored for analysis

Correlation0.9473213605

qt_funcionarios_12meses
Highly correlated

This variable is highly correlated with qt_funcionarios and should be ignored for analysis

Correlation0.9976051149

qt_funcionarios_24meses
Highly correlated

This variable is highly correlated with qt_funcionarios_12meses and should be ignored for analysis

Correlation0.9833377759

qt_funcionarios_coligados
Numeric

Distinct count163
Unique (%)28.8%
Missing (%)55.5%
Missing (n)314
Infinite (%)0.0%
Infinite (n)0
Mean359.6626984
Minimum0
Maximum7222
Zeros (%)3.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q110.75
Median80.5
Q3229.25
95-th percentile1727.75
Maximum7222
Range7222
Interquartile range218.5

Descriptive statistics

Standard deviation897.3871775
Coef of variation2.495079922
Kurtosis21.64541435
Mean359.6626984
MAD460.5121252
Skewness4.341758648
Sum90635
Variance805303.7463
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0 18 3.2%
 
1 9 1.6%
 
3 7 1.2%
 
2 5 0.9%
 
4 4 0.7%
 
9 4 0.7%
 
7 4 0.7%
 
6 4 0.7%
 
12 3 0.5%
 
20 3 0.5%
 
Other values (152) 191 33.7%
 
(Missing) 314 55.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 18 3.2%
 
1 9 1.6%
 
2 5 0.9%
 
3 7 1.2%
 
4 4 0.7%
 

Maximum 5 values

ValueCountFrequency (%) 
7222 1 0.2%
 
4770 1 0.2%
 
4487 1 0.2%
 
4311 1 0.2%
 
4124 1 0.2%
 

qt_funcionarios_coligados_gp
Highly correlated

This variable is highly correlated with media_filiais_coligados and should be ignored for analysis

Correlation0.9060538336

qt_funcionarios_grupo
Numeric

Distinct count351
Unique (%)62.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean580.9823322
Minimum17
Maximum95202
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum17
5-th percentile60.25
Q199
Median178
Q3375.25
95-th percentile1285.25
Maximum95202
Range95185
Interquartile range276.25

Descriptive statistics

Standard deviation4111.154065
Coef of variation7.076211852
Kurtosis499.531826
Mean580.9823322
MAD662.1149097
Skewness21.81140653
Sum328836
Variance16901587.74
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[1.7000e+01 4.9500e+01 1.2750e+02 2.1350e+02 4.1450e+02 7.8950e+02 1.6140e+03 6.3160e+03 9.5202e+04], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
96 7 1.2%
 
98 7 1.2%
 
71 7 1.2%
 
94 6 1.1%
 
123 6 1.1%
 
142 6 1.1%
 
110 5 0.9%
 
77 5 0.9%
 
73 5 0.9%
 
79 4 0.7%
 
Other values (341) 508 89.8%
 

Minimum 5 values

ValueCountFrequency (%) 
17 1 0.2%
 
21 1 0.2%
 
38 1 0.2%
 
40 1 0.2%
 
42 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
95202 1 0.2%
 
17969 1 0.2%
 
6622 1 0.2%
 
6010 1 0.2%
 
5759 1 0.2%
 

qt_ramos_coligados
Numeric

Distinct count22
Unique (%)3.9%
Missing (%)47.2%
Missing (n)267
Infinite (%)0.0%
Infinite (n)0
Mean4.130434783
Minimum1
Maximum30
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median3
Q35
95-th percentile12.1
Maximum30
Range29
Interquartile range4

Descriptive statistics

Standard deviation4.189277237
Coef of variation1.014246068
Kurtosis11.04882194
Mean4.130434783
MAD2.78871601
Skewness2.822121905
Sum1235
Variance17.55004377
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=22)
ValueCountFrequency (%) 
1 76 13.4%
 
2 54 9.5%
 
3 53 9.4%
 
4 31 5.5%
 
5 20 3.5%
 
7 14 2.5%
 
8 11 1.9%
 
6 10 1.8%
 
10 9 1.6%
 
15 3 0.5%
 
Other values (11) 18 3.2%
 
(Missing) 267 47.2%
 

Minimum 5 values

ValueCountFrequency (%) 
1 76 13.4%
 
2 54 9.5%
 
3 53 9.4%
 
4 31 5.5%
 
5 20 3.5%
 

Maximum 5 values

ValueCountFrequency (%) 
30 2 0.4%
 
21 1 0.2%
 
19 1 0.2%
 
18 2 0.4%
 
17 1 0.2%
 

qt_regioes_coligados
Numeric

Distinct count6
Unique (%)1.1%
Missing (%)47.2%
Missing (n)267
Infinite (%)0.0%
Infinite (n)0
Mean1.344481605
Minimum1
Maximum5
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q31.5
95-th percentile3
Maximum5
Range4
Interquartile range0.5

Descriptive statistics

Standard deviation0.6939779184
Coef of variation0.5161676557
Kurtosis6.163052716
Mean1.344481605
MAD0.5161463518
Skewness2.390106108
Sum402
Variance0.4816053512
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%) 
1 224 39.6%
 
2 56 9.9%
 
3 11 1.9%
 
4 7 1.2%
 
5 1 0.2%
 
(Missing) 267 47.2%
 

Minimum 5 values

ValueCountFrequency (%) 
1 224 39.6%
 
2 56 9.9%
 
3 11 1.9%
 
4 7 1.2%
 
5 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
5 1 0.2%
 
4 7 1.2%
 
3 11 1.9%
 
2 56 9.9%
 
1 224 39.6%
 

qt_socios
Numeric

Distinct count15
Unique (%)2.7%
Missing (%)32.5%
Missing (n)184
Infinite (%)0.0%
Infinite (n)0
Mean3.09947644
Minimum1
Maximum139
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q12
Median2
Q33
95-th percentile6
Maximum139
Range138
Interquartile range1

Descriptive statistics

Standard deviation7.236575932
Coef of variation2.334773654
Kurtosis328.7762402
Mean3.09947644
MAD1.680326745
Skewness17.54697951
Sum1184
Variance52.36803122
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=15)
ValueCountFrequency (%) 
2 181 32.0%
 
3 65 11.5%
 
1 55 9.7%
 
4 42 7.4%
 
5 14 2.5%
 
6 13 2.3%
 
7 3 0.5%
 
9 3 0.5%
 
139 1 0.2%
 
13 1 0.2%
 
Other values (4) 4 0.7%
 
(Missing) 184 32.5%
 

Minimum 5 values

ValueCountFrequency (%) 
1 55 9.7%
 
2 181 32.0%
 
3 65 11.5%
 
4 42 7.4%
 
5 14 2.5%
 

Maximum 5 values

ValueCountFrequency (%) 
139 1 0.2%
 
22 1 0.2%
 
14 1 0.2%
 
13 1 0.2%
 
12 1 0.2%
 

qt_socios_coligados
Highly correlated

This variable is highly correlated with qt_coligados_matriz and should be ignored for analysis

Correlation0.9679088493

qt_socios_feminino
Highly correlated

This variable is highly correlated with qt_socios and should be ignored for analysis

Correlation0.98778012

qt_socios_masculino
Highly correlated

This variable is highly correlated with qt_socios_feminino and should be ignored for analysis

Correlation0.96613456

qt_socios_pep
Highly correlated

This variable is highly correlated with qt_socios_masculino and should be ignored for analysis

Correlation0.9767644238

qt_socios_pf
Highly correlated

This variable is highly correlated with qt_socios_pep and should be ignored for analysis

Correlation0.9745025748

qt_socios_pj
Categorical

Distinct count5
Unique (%)0.9%
Missing (%)32.5%
Missing (n)184
0
331
1
 
35
2
 
15
(Missing)
184
ValueCountFrequency (%) 
0 331 58.5%
 
1 35 6.2%
 
2 15 2.7%
 
3 1 0.2%
 
(Missing) 184 32.5%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

qt_socios_pj_ativos
Highly correlated

This variable is highly correlated with qt_socios_pj and should be ignored for analysis

Correlation0.962828788

qt_socios_pj_baixados
Boolean

Distinct count3
Unique (%)0.5%
Missing (%)91.0%
Missing (n)515
0
 
50
1
 
1
(Missing)
515
ValueCountFrequency (%) 
0 50 8.8%
 
1 1 0.2%
 
(Missing) 515 91.0%
 

qt_socios_pj_inaptos
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)91.0%
Missing (n)515
0
 
51
(Missing)
515
ValueCountFrequency (%) 
0 51 9.0%
 
(Missing) 515 91.0%
 

qt_socios_pj_nulos
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)91.0%
Missing (n)515
0
 
51
(Missing)
515
ValueCountFrequency (%) 
0 51 9.0%
 
(Missing) 515 91.0%
 

qt_socios_pj_suspensos
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)91.0%
Missing (n)515
0
 
51
(Missing)
515
ValueCountFrequency (%) 
0 51 9.0%
 
(Missing) 515 91.0%
 

qt_socios_st_regular
Highly correlated

This variable is highly correlated with qt_socios_pf and should be ignored for analysis

Correlation0.9943253402

qt_socios_st_suspensa
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)99.8%
Missing (n)565
1
 
1
(Missing)
565
ValueCountFrequency (%) 
1 1 0.2%
 
(Missing) 565 99.8%
 

qt_ufs_coligados
Numeric

Distinct count12
Unique (%)2.1%
Missing (%)47.2%
Missing (n)267
Infinite (%)0.0%
Infinite (n)0
Mean1.745819398
Minimum1
Maximum11
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q32
95-th percentile5
Maximum11
Range10
Interquartile range1

Descriptive statistics

Standard deviation1.557275924
Coef of variation0.8920028759
Kurtosis14.30472041
Mean1.745819398
MAD0.9578416349
Skewness3.48334197
Sum522
Variance2.425108303
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=12)
ValueCountFrequency (%) 
1 192 33.9%
 
2 64 11.3%
 
3 22 3.9%
 
5 6 1.1%
 
4 4 0.7%
 
6 3 0.5%
 
7 2 0.4%
 
11 2 0.4%
 
9 2 0.4%
 
10 1 0.2%
 
(Missing) 267 47.2%
 

Minimum 5 values

ValueCountFrequency (%) 
1 192 33.9%
 
2 64 11.3%
 
3 22 3.9%
 
4 4 0.7%
 
5 6 1.1%
 

Maximum 5 values

ValueCountFrequency (%) 
11 2 0.4%
 
10 1 0.2%
 
9 2 0.4%
 
8 1 0.2%
 
7 2 0.4%
 

setor
Categorical

Distinct count5
Unique (%)0.9%
Missing (%)0.0%
Missing (n)0
SERVIÇO
336
COMERCIO
107
INDUSTRIA
69
Other values (2)
 
54
ValueCountFrequency (%) 
SERVIÇO 336 59.4%
 
COMERCIO 107 18.9%
 
INDUSTRIA 69 12.2%
 
CONSTRUÇÃO CIVIL 46 8.1%
 
AGROPECUARIA 8 1.4%
 
Max length16
Mean length8.234982332
Min length7
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

sg_uf
Categorical

Distinct count6
Unique (%)1.1%
Missing (%)0.0%
Missing (n)0
AM
142
MA
118
PI
101
Other values (3)
205
ValueCountFrequency (%) 
AM 142 25.1%
 
MA 118 20.8%
 
PI 101 17.8%
 
RN 100 17.7%
 
RO 70 12.4%
 
AC 35 6.2%
 
Max length2
Mean length2
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

sg_uf_matriz
Recoded

This variable is a recoding of sg_uf and should be ignored for analysis

sum_faturamento_estimado_coligadas
Highly correlated

This variable is highly correlated with faturamento_est_coligados_gp and should be ignored for analysis

Correlation0.96717436

total
Highly correlated

This variable is highly correlated with qt_funcionarios_24meses and should be ignored for analysis

Correlation0.9784337577

total_filiais_coligados
Highly correlated

This variable is highly correlated with qt_funcionarios_coligados_gp and should be ignored for analysis

Correlation0.9215779475

tx_crescimento_12meses
Numeric

Distinct count355
Unique (%)62.7%
Missing (%)0.2%
Missing (n)1
Infinite (%)0.0%
Infinite (n)0
Mean4.744763716
Minimum-79.46210269
Maximum376.3157895
Zeros (%)34.5%
Mini histogram

Quantile statistics

Minimum-79.46210269
5-th percentile-18.05100182
Q1-0.9803921569
Median0
Q35
95-th percentile35.84615385
Maximum376.3157895
Range455.7778922
Interquartile range5.980392157

Descriptive statistics

Standard deviation28.29391768
Coef of variation5.963187921
Kurtosis74.96195462
Mean4.744763716
MAD12.07533434
Skewness6.999768766
Sum2680.791499
Variance800.5457774
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0 195 34.5%
 
2.564102564 3 0.5%
 
1.063829787 3 0.5%
 
11.32075472 2 0.4%
 
-3.571428571 2 0.4%
 
-8.695652174 2 0.4%
 
-2.02020202 2 0.4%
 
21.9047619 2 0.4%
 
7.03125 2 0.4%
 
-1.351351351 2 0.4%
 
Other values (344) 350 61.8%
 

Minimum 5 values

ValueCountFrequency (%) 
-79.46210269 1 0.2%
 
-65.94827586 1 0.2%
 
-44.30379747 1 0.2%
 
-41.26984127 1 0.2%
 
-40.85418464 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
376.3157895 1 0.2%
 
290.4761905 1 0.2%
 
181.5498155 1 0.2%
 
133.3333333 1 0.2%
 
126.6666667 1 0.2%
 

tx_crescimento_24meses
Highly correlated

This variable is highly correlated with qt_socios_pep and should be ignored for analysis

Correlation0.9638549677

tx_rotatividade
Numeric

Distinct count362
Unique (%)64.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean13.80058026
Minimum0
Maximum133.877551
Zeros (%)33.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median8.463573464
Q319.84045114
95-th percentile46.41971928
Maximum133.877551
Range133.877551
Interquartile range19.84045114

Descriptive statistics

Standard deviation18.28756409
Coef of variation1.325130084
Kurtosis8.870683905
Mean13.80058026
MAD12.95046644
Skewness2.455336047
Sum7811.128428
Variance334.4350003
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.00000000e+00 1.39295166e-02 2.26734117e+01 4.26816479e+01 5.92415730e+01 1.33877551e+02], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 188 33.2%
 
38.46153846 3 0.5%
 
5.22875817 2 0.4%
 
10.90909091 2 0.4%
 
10.81081081 2 0.4%
 
3.773584906 2 0.4%
 
19.35483871 2 0.4%
 
8.275862069 2 0.4%
 
16.66666667 2 0.4%
 
8.438818565 2 0.4%
 
Other values (352) 359 63.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 188 33.2%
 
0.02785903329 1 0.2%
 
0.1338688086 1 0.2%
 
0.1431639227 1 0.2%
 
0.289017341 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
133.877551 1 0.2%
 
114.4278607 1 0.2%
 
113.9622642 1 0.2%
 
106.6666667 1 0.2%
 
95.9040959 1 0.2%
 

Unnamed_0_x
Numeric

Distinct count566
Unique (%)100.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean282.5
Minimum0
Maximum565
Zeros (%)0.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile28.25
Q1141.25
Median282.5
Q3423.75
95-th percentile536.75
Maximum565
Range565
Interquartile range282.5

Descriptive statistics

Standard deviation163.5344001
Coef of variation0.578882832
Kurtosis-1.2
Mean282.5
MAD141.5
Skewness0
Sum159895
Variance26743.5
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 565.], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
565 1 0.2%
 
185 1 0.2%
 
191 1 0.2%
 
190 1 0.2%
 
189 1 0.2%
 
188 1 0.2%
 
187 1 0.2%
 
186 1 0.2%
 
184 1 0.2%
 
193 1 0.2%
 
Other values (556) 556 98.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1 0.2%
 
1 1 0.2%
 
2 1 0.2%
 
3 1 0.2%
 
4 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
565 1 0.2%
 
564 1 0.2%
 
563 1 0.2%
 
562 1 0.2%
 
561 1 0.2%
 

Unnamed_0_y
Highly correlated

This variable is highly correlated with Unnamed_0_x and should be ignored for analysis

Correlation0.9992144689

vl_faturamento_estimado_aux
Numeric

Distinct count480
Unique (%)84.8%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean81048876.99
Minimum10014710
Maximum3490930200
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum10014710
5-th percentile11024424
Q118507123
Median30406264
Q363313162.5
95-th percentile292494967.5
Maximum3490930200
Range3480915490
Interquartile range44806039.5

Descriptive statistics

Standard deviation222054882.4
Coef of variation2.739765074
Kurtosis119.2737904
Mean81048876.99
MAD82626810.74
Skewness9.581904578
Sum4.587366438e+10
Variance4.930837081e+16
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[1.00147100e+07 1.25183880e+07 3.11414220e+07 4.10840100e+07 7.22769500e+07 1.53105555e+08 5.26290040e+08 3.49093020e+09], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
11024424 5 0.9%
 
19266984 5 0.9%
 
27354996 3 0.5%
 
11591100 3 0.5%
 
17515440 3 0.5%
 
12466872 3 0.5%
 
21327624 3 0.5%
 
10045620 3 0.5%
 
15763896 3 0.5%
 
11745648 3 0.5%
 
Other values (470) 532 94.0%
 

Minimum 5 values

ValueCountFrequency (%) 
10014710 1 0.2%
 
10045620 3 0.5%
 
10097136 2 0.4%
 
10138349 1 0.2%
 
10148652 2 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
3490930200 1 0.2%
 
2068779500 1 0.2%
 
1700543100 1 0.2%
 
1535382900 1 0.2%
 
1375889300 1 0.2%
 

vl_faturamento_estimado_grupo_aux
Numeric

Distinct count528
Unique (%)93.3%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean99899642.54
Minimum10014710
Maximum4663801000
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum10014710
5-th percentile11552463
Q120204033.5
Median34929816
Q375112364
95-th percentile326611430
Maximum4663801000
Range4653786290
Interquartile range54908330.5

Descriptive statistics

Standard deviation303036209.1
Coef of variation3.03340634
Kurtosis125.5056446
Mean99899642.54
MAD105150905.7
Skewness10.05482469
Sum5.654319768e+10
Variance9.183094401e+16
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[1.00147100e+07 3.09921700e+07 6.07708500e+07 9.03075470e+07 1.53592375e+08 2.69689685e+08 6.77425150e+08 4.66380100e+09], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
11024424 5 0.9%
 
11745648 3 0.5%
 
27354996 3 0.5%
 
40955220 3 0.5%
 
10921392 3 0.5%
 
30497472 3 0.5%
 
12312324 2 0.4%
 
21327624 2 0.4%
 
40130964 2 0.4%
 
10097136 2 0.4%
 
Other values (518) 538 95.1%
 

Minimum 5 values

ValueCountFrequency (%) 
10014710 1 0.2%
 
10045620 2 0.4%
 
10097136 2 0.4%
 
10138349 1 0.2%
 
10406232 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
4663801000 1 0.2%
 
3519985000 1 0.2%
 
2077659500 1 0.2%
 
1700543100 1 0.2%
 
1554512900 1 0.2%
 

vl_folha_coligados
Highly correlated

This variable is highly correlated with qt_funcionarios_coligados and should be ignored for analysis

Correlation0.9216477572

vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with max_vl_folha_coligados_gp and should be ignored for analysis

Correlation0.9057230661

vl_frota
Numeric

Distinct count467
Unique (%)82.5%
Missing (%)17.3%
Missing (n)98
Infinite (%)0.0%
Infinite (n)0
Mean964786.9615
Minimum3435
Maximum38320340
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum3435
5-th percentile25750.7
Q1100638
Median297365.5
Q3631261.25
95-th percentile3712779.65
Maximum38320340
Range38316905
Interquartile range530623.25

Descriptive statistics

Standard deviation2790322.899
Coef of variation2.89216481
Kurtosis78.56882873
Mean964786.9615
MAD1140703.795
Skewness7.568678701
Sum451520298
Variance7.785901883e+12
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
173900 2 0.4%
 
64657 2 0.4%
 
272549 1 0.2%
 
40655 1 0.2%
 
59795 1 0.2%
 
587057 1 0.2%
 
306841 1 0.2%
 
254541 1 0.2%
 
672056 1 0.2%
 
34236 1 0.2%
 
Other values (456) 456 80.6%
 
(Missing) 98 17.3%
 

Minimum 5 values

ValueCountFrequency (%) 
3435 1 0.2%
 
3611 1 0.2%
 
3705 1 0.2%
 
4361 1 0.2%
 
4610 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
38320340 1 0.2%
 
18659658 1 0.2%
 
16422955 1 0.2%
 
15786727 1 0.2%
 
15604468 1 0.2%
 

vl_idade_maxima_socios_pj
Numeric

Distinct count51
Unique (%)9.0%
Missing (%)91.0%
Missing (n)515
Infinite (%)0.0%
Infinite (n)0
Mean13.37445478
Minimum0.7611225188
Maximum52.28199863
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum0.7611225188
5-th percentile1.660506502
Q14.182067077
Median7.101984942
Q318.65845311
95-th percentile39.64818617
Maximum52.28199863
Range51.52087611
Interquartile range14.47638604

Descriptive statistics

Standard deviation12.98527543
Coef of variation0.9709012921
Kurtosis1.344825597
Mean13.37445478
MAD10.24005667
Skewness1.410092126
Sum682.0971937
Variance168.6173779
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
15.34291581 2 0.4%
 
17.29774127 1 0.2%
 
12.15879535 1 0.2%
 
4.079397673 1 0.2%
 
3.556468172 1 0.2%
 
34.24229979 1 0.2%
 
19.1211499 1 0.2%
 
2.061601643 1 0.2%
 
0.8678986995 1 0.2%
 
15.43874059 1 0.2%
 
Other values (40) 40 7.1%
 
(Missing) 515 91.0%
 

Minimum 5 values

ValueCountFrequency (%) 
0.7611225188 1 0.2%
 
0.8678986995 1 0.2%
 
1.338809035 1 0.2%
 
1.98220397 1 0.2%
 
2.061601643 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
52.28199863 1 0.2%
 
49.3744011 1 0.2%
 
41.4017796 1 0.2%
 
37.89459274 1 0.2%
 
34.24229979 1 0.2%
 

vl_idade_media_socios_pj
Highly correlated

This variable is highly correlated with vl_idade_maxima_socios_pj and should be ignored for analysis

Correlation0.9332295218

vl_idade_minima_socios_pj
Highly correlated

This variable is highly correlated with vl_idade_media_socios_pj and should be ignored for analysis

Correlation0.9251854481

vl_potenc_cons_oleo_gas
Numeric

Distinct count62
Unique (%)11.0%
Missing (%)83.4%
Missing (n)472
Infinite (%)0.0%
Infinite (n)0
Mean78.46808511
Minimum1
Maximum1080
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile3
Q114.25
Median44.5
Q381.5
95-th percentile308.45
Maximum1080
Range1079
Interquartile range67.25

Descriptive statistics

Standard deviation136.4184503
Coef of variation1.738521466
Kurtosis31.58615066
Mean78.46808511
MAD73.75101856
Skewness4.88649026
Sum7376
Variance18609.99359
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
45 8 1.4%
 
6 5 0.9%
 
4 5 0.9%
 
18 4 0.7%
 
20 3 0.5%
 
3 3 0.5%
 
7 3 0.5%
 
60 3 0.5%
 
30 2 0.4%
 
2 2 0.4%
 
Other values (51) 56 9.9%
 
(Missing) 472 83.4%
 

Minimum 5 values

ValueCountFrequency (%) 
1 1 0.2%
 
2 2 0.4%
 
3 3 0.5%
 
4 5 0.9%
 
5 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
1080 1 0.2%
 
430 1 0.2%
 
380 1 0.2%
 
374 1 0.2%
 
352 1 0.2%
 

vl_total_tancagem
Highly correlated

This variable is highly correlated with vl_potenc_cons_oleo_gas and should be ignored for analysis

Correlation0.9431314001

vl_total_tancagem_grupo
Numeric

Distinct count11
Unique (%)1.9%
Missing (%)94.7%
Missing (n)536
Infinite (%)0.0%
Infinite (n)0
Mean45.86666667
Minimum10
Maximum385
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum10
5-th percentile15
Q115
Median17.5
Q330
95-th percentile177.5
Maximum385
Range375
Interquartile range15

Descriptive statistics

Standard deviation78.13416107
Coef of variation1.703506419
Kurtosis13.53698841
Mean45.86666667
MAD42.16888889
Skewness3.607892059
Sum1376
Variance6104.947126
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%) 
15 14 2.5%
 
30 5 0.9%
 
20 3 0.5%
 
45 2 0.4%
 
245 1 0.2%
 
385 1 0.2%
 
10 1 0.2%
 
91 1 0.2%
 
95 1 0.2%
 
40 1 0.2%
 
(Missing) 536 94.7%
 

Minimum 5 values

ValueCountFrequency (%) 
10 1 0.2%
 
15 14 2.5%
 
20 3 0.5%
 
30 5 0.9%
 
40 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
385 1 0.2%
 
245 1 0.2%
 
95 1 0.2%
 
91 1 0.2%
 
45 2 0.4%
 

vl_total_veiculos_antt
Highly correlated

This variable is highly correlated with vl_total_tancagem_grupo and should be ignored for analysis

Correlation0.9643989074

vl_total_veiculos_antt_grupo
Highly correlated

This variable is highly correlated with vl_total_veiculos_antt and should be ignored for analysis

Correlation1

vl_total_veiculos_leves
Numeric

Distinct count59
Unique (%)10.4%
Missing (%)13.4%
Missing (n)76
Infinite (%)0.0%
Infinite (n)0
Mean11.64489796
Minimum0
Maximum359
Zeros (%)8.3%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q12
Median5
Q310
95-th percentile41.55
Maximum359
Range359
Interquartile range8

Descriptive statistics

Standard deviation27.50676482
Coef of variation2.362130172
Kurtosis64.12955307
Mean11.64489796
MAD12.08806331
Skewness6.857399029
Sum5706
Variance756.6221109
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
1 61 10.8%
 
2 51 9.0%
 
0 47 8.3%
 
3 46 8.1%
 
5 38 6.7%
 
4 33 5.8%
 
6 23 4.1%
 
7 23 4.1%
 
10 19 3.4%
 
9 17 3.0%
 
Other values (48) 132 23.3%
 
(Missing) 76 13.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 47 8.3%
 
1 61 10.8%
 
2 51 9.0%
 
3 46 8.1%
 
4 33 5.8%
 

Maximum 5 values

ValueCountFrequency (%) 
359 1 0.2%
 
194 1 0.2%
 
170 1 0.2%
 
167 1 0.2%
 
164 1 0.2%
 

vl_total_veiculos_leves_grupo
Highly correlated

This variable is highly correlated with vl_total_veiculos_leves and should be ignored for analysis

Correlation0.9590222257

vl_total_veiculos_pesados
Numeric

Distinct count59
Unique (%)10.4%
Missing (%)13.4%
Missing (n)76
Infinite (%)0.0%
Infinite (n)0
Mean9.848979592
Minimum0
Maximum215
Zeros (%)29.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median2
Q38
95-th percentile46
Maximum215
Range215
Interquartile range8

Descriptive statistics

Standard deviation24.11479128
Coef of variation2.448455808
Kurtosis30.72932261
Mean9.848979592
MAD12.20226572
Skewness5.01854294
Sum4826
Variance581.5231585
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0 165 29.2%
 
1 55 9.7%
 
2 42 7.4%
 
3 29 5.1%
 
4 24 4.2%
 
7 19 3.4%
 
5 15 2.7%
 
9 14 2.5%
 
6 13 2.3%
 
8 11 1.9%
 
Other values (48) 103 18.2%
 
(Missing) 76 13.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 165 29.2%
 
1 55 9.7%
 
2 42 7.4%
 
3 29 5.1%
 
4 24 4.2%
 

Maximum 5 values

ValueCountFrequency (%) 
215 1 0.2%
 
190 1 0.2%
 
187 1 0.2%
 
176 1 0.2%
 
142 1 0.2%
 

vl_total_veiculos_pesados_grupo
Numeric

Distinct count65
Unique (%)11.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean10.40812721
Minimum0
Maximum663
Zeros (%)41.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median1
Q37
95-th percentile46
Maximum663
Range663
Interquartile range7

Descriptive statistics

Standard deviation36.86571476
Coef of variation3.542012316
Kurtosis179.1706174
Mean10.40812721
MAD13.94412466
Skewness11.32848274
Sum5891
Variance1359.080925
Memory size28.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.000e+00 5.000e-01 2.500e+00 4.500e+00 1.050e+01 2.050e+01 4.950e+01 2.025e+02 6.630e+02], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 237 41.9%
 
1 54 9.5%
 
2 41 7.2%
 
3 28 4.9%
 
4 25 4.4%
 
5 17 3.0%
 
7 16 2.8%
 
6 15 2.7%
 
9 13 2.3%
 
10 10 1.8%
 
Other values (55) 110 19.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 237 41.9%
 
1 54 9.5%
 
2 41 7.2%
 
3 28 4.9%
 
4 25 4.4%
 

Maximum 5 values

ValueCountFrequency (%) 
663 1 0.2%
 
215 1 0.2%
 
190 1 0.2%
 
187 1 0.2%
 
179 1 0.2%
 

Correlations

Missing values

Sample

First rows

coligada_mais_antiga_ativacoligada_mais_antiga_baixadacoligada_mais_nova_ativacoligada_mais_nova_baixadade_faixa_faturamento_estimadode_faixa_faturamento_estimado_grupode_indicador_telefonede_natureza_juridicade_nivel_atividadede_ramode_saude_rescenciade_saude_tributariadt_situacaoempsetorcensitariofaixarendapopulacaofaturamento_est_coligadosfaturamento_est_coligados_gpfl_anttfl_emailfl_eppfl_ltdafl_matrizfl_mefl_meifl_optante_simeifl_optante_simplesfl_passivel_issfl_rmfl_safl_simples_irregularfl_spafl_st_especialfl_telefonefl_veiculograu_instrucao_macro_analfabetograu_instrucao_macro_desconhecidograu_instrucao_macro_escolaridade_fundamentalgrau_instrucao_macro_escolaridade_mediagrau_instrucao_macro_escolaridade_superiorididade_acima_de_58idade_ate_18idade_de_19_a_23idade_de_24_a_28idade_de_29_a_33idade_de_34_a_38idade_de_39_a_43idade_de_44_a_48idade_de_49_a_53idade_de_54_a_58idade_emp_catidade_empresa_anosidade_maxima_coligadasidade_maxima_sociosidade_media_coligadasidade_media_coligadas_ativasidade_media_coligadas_baixadasidade_media_sociosidade_minima_coligadasidade_minima_sociosmax_faturamento_est_coligadosmax_faturamento_est_coligados_gpmax_filiais_coligadosmax_funcionarios_coligados_gpmax_meses_servicosmax_meses_servicos_allmax_vl_folha_coligadosmax_vl_folha_coligados_gpmedia_faturamento_est_coligadosmedia_faturamento_est_coligados_gpmedia_filiais_coligadosmedia_funcionarios_coligados_gpmedia_meses_servicosmedia_meses_servicos_allmedia_vl_folha_coligadosmedia_vl_folha_coligados_gpmeses_ultima_contratacacomin_faturamento_est_coligadosmin_faturamento_est_coligados_gpmin_filiais_coligadosmin_funcionarios_coligados_gpmin_meses_servicosmin_meses_servicos_allmin_vl_folha_coligadosmin_vl_folha_coligados_gpnatureza_juridica_macronm_divisaonm_meso_regiaonm_micro_regiaonm_segmentonu_meses_rescenciapercent_func_genero_fempercent_func_genero_mascqt_admitidosqt_admitidos_12mesesqt_alteracao_socio_180dqt_alteracao_socio_365dqt_alteracao_socio_90dqt_alteracao_socio_totalqt_artqt_coligadasqt_coligadosqt_coligados_agropecuariaqt_coligados_atividade_altoqt_coligados_atividade_baixoqt_coligados_atividade_inativoqt_coligados_atividade_medioqt_coligados_atividade_mt_baixoqt_coligados_ativoqt_coligados_baixadaqt_coligados_ccivilqt_coligados_centroqt_coligados_comercioqt_coligados_eppqt_coligados_exteriorqt_coligados_inaptaqt_coligados_industriaqt_coligados_ltdaqt_coligados_matrizqt_coligados_meqt_coligados_meiqt_coligados_nordesteqt_coligados_norteqt_coligados_nulaqt_coligados_saqt_coligados_serviçoqt_coligados_sudesteqt_coligados_sulqt_coligados_suspensaqt_desligadosqt_desligados_12mesesqt_ex_funcionariosqt_filiaisqt_funcionariosqt_funcionarios_12mesesqt_funcionarios_24mesesqt_funcionarios_coligadosqt_funcionarios_coligados_gpqt_funcionarios_grupoqt_ramos_coligadosqt_regioes_coligadosqt_sociosqt_socios_coligadosqt_socios_femininoqt_socios_masculinoqt_socios_pepqt_socios_pfqt_socios_pjqt_socios_pj_ativosqt_socios_pj_baixadosqt_socios_pj_inaptosqt_socios_pj_nulosqt_socios_pj_suspensosqt_socios_st_regularqt_socios_st_suspensaqt_ufs_coligadossetorsg_ufsg_uf_matrizsum_faturamento_estimado_coligadastotaltotal_filiais_coligadostx_crescimento_12mesestx_crescimento_24mesestx_rotatividadeUnnamed_0_xUnnamed_0_yvl_faturamento_estimado_auxvl_faturamento_estimado_grupo_auxvl_folha_coligadosvl_folha_coligados_gpvl_frotavl_idade_maxima_socios_pjvl_idade_media_socios_pjvl_idade_minima_socios_pjvl_potenc_cons_oleo_gasvl_total_tancagemvl_total_tancagem_grupovl_total_veiculos_anttvl_total_veiculos_antt_grupovl_total_veiculos_levesvl_total_veiculos_leves_grupovl_total_veiculos_pesadosvl_total_veiculos_pesados_grupo
0NaNNaNNaNNaNDE R$ 300.000.000,01 A R$ 500.000.000,00DE R$ 300.000.000,01 A R$ 500.000.000,00BOAAUTARQUIA ESTADUAL OU DO DISTRITO FEDERALALTAADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIALACIMA DE 1 ANOVERDE2007-08-032791.15NaNNaNFalseTrueFalseFalseTrueFalseFalseFalseFalseTrueNAOFalseFalseFalseFalseTrueTrueNaNNaN2.0523.0836.009e95c1a84049001d086470a8f320a19b076f955a89122...2.0NaNNaN23.0411.0508.0282.0103.022.010.010 a 1511.243836NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN357.066667357.066667NaNNaNNaNNaNNaNNaN99.96100984.967827NaNNaN25.533333NaNNaNNaNNaN25.533333-6.500000NaNNaNADMINISTRACAO PUBLICAADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIALVALE DO ACRERIO BRANCOADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL23.018.2281.781812.00.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN451.00.0451.001361.01361.01383.0NaNNaN1361.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNSERVIÇOACACNaN1361.0NaN0.000000-1.5907450.00000001646327487200.0327487200.0NaNNaN46132.0NaNNaNNaNNaNNaNNaNNaNNaN4.04.00.00.0
1NaNNaNNaNNaNDE R$ 100.000.000,01 A R$ 300.000.000,00DE R$ 100.000.000,01 A R$ 300.000.000,00BOAMUNICIPIOALTAADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIALACIMA DE 1 ANOVERDE2004-12-111007.87NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseFalseTrueNaNNaN54.0414.0523.0dc9d155f5bcd3172031e2ec9431786e8871ff4b0ff4728...123.0NaN11.059.0104.0157.0129.0163.0113.0132.0> 2043.789041NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN526.1333335014.966667NaNNaNNaNNaNNaNNaN149.17309180.756709NaNNaN23.200000NaNNaNNaNNaN23.200000-9.233333NaNNaNOUTROSADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIALAGRESTE POTIGUARAGRESTE POTIGUARADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL23.057.1142.892352.00.0NaNNaNNaNNaN8.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1361.00.01359.00991.0991.01306.0NaNNaN991.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNSERVIÇORNRNNaN991.0NaN0.000000-24.1194490.00000012696176802910.0176802910.0NaNNaN1309391.0NaNNaNNaNNaNNaNNaNNaNNaN20.020.016.016.0
2NaNNaNNaNNaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 10.000.000,01 A R$ 30.000.000,00BOASOCIEDADE SIMPLES LIMITADAALTASERVICOS DE EDUCACAOACIMA DE 1 ANOVERDE2005-09-24688.31NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseTrueNAOFalseFalseFalseFalseTrueTrueNaNNaN19.09.091.016843c9ffb920170477118933798510d8d5f00f5c56c12...2.0NaN1.010.027.030.020.015.011.03.015 a 2016.389041NaN70.0NaNNaNNaN70.000000NaN70.0NaNNaNNaNNaN149.033333149.033333NaNNaNNaNNaNNaNNaN65.94201742.166782NaNNaN4.866667NaNNaNNaNNaN4.8666670.000000NaNNaNENTIDADES EMPRESARIAISEDUCACAONORTE PIAUIENSEBAIXO PARNAIBA PIAUIENSEEDUCACAO23.047.9052.10291.021.0NaNNaNNaNNaN1.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN172.07.0172.00119.0104.0113.0NaNNaN119.0NaNNaN2.0NaN1.0NaNNaN2.00.0NaNNaNNaNNaNNaN1.0NaNNaNSERVIÇOPIPINaN119.0NaN14.4230775.3097356.2500002368127818640.027818640.0NaNNaN60101.0NaNNaNNaNNaNNaNNaNNaNNaN1.01.01.01.0
3NaNNaNNaNNaNDE R$ 100.000.000,01 A R$ 300.000.000,00DE R$ 100.000.000,01 A R$ 300.000.000,00NaNMUNICIPIOALTAADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIALACIMA DE 1 ANOVERDE2005-09-241397.47NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseTrueNAOFalseFalseFalseFalseFalseFalseNaNNaN8.022.01794.0ff045934d90aab184dd15e66daf3b3c97193bda5449298...143.0NaN16.090.0213.0352.0382.0264.0199.0165.0> 2039.671233NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN555.766667555.766667NaNNaNNaNNaNNaNNaN144.013013140.449941NaNNaN28.300000NaNNaNNaNNaN28.3000000.966667NaNNaNOUTROSADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIALSUDOESTE AMAZONENSEALTO SOLIMOESADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL23.051.9748.031971.00.0NaNNaNNaNNaN11.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN142.00.0141.011829.01829.01875.0NaNNaN1824.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNSERVIÇOAMAMNaN1824.0NaN0.000000-2.4533330.00000034564221518800.0221518800.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
4372.066667NaN172.400000NaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 10.000.000,01 A R$ 30.000.000,00NaNSOCIEDADE EMPRESARIA LIMITADAALTAPRODUTOS DE AGROPECUARIAACIMA DE 1 ANOVERDE2005-11-03707.2014789028.016899028.0TrueFalseFalseFalseTrueFalseFalseFalseFalseTrueNAOFalseFalseFalseFalseFalseTrue14.0NaN153.05.03.0a0ce528caab2c62497a548d0ebd9e935143ef81ed7dbf0...1.03.021.019.026.023.031.026.014.011.0> 2020.268493372.06666770.0243.600000243.600000NaN48.666667172.40000036.010148652.012258652.01.065.0134.833333179.7666674059460.84059460.84929676.05.633009e+061.061.514.61073411.0008692.915806e+062.915806e+062.933333210000.0210000.01.058.02.933333-0.5666671772150.41772150.4ENTIDADES EMPRESARIAISAGRICULTURA PECUARIA E SERVICOS RELACIONADOSOESTE POTIGUARMOSSOROAGRICULTURA PECUARIA PRODUCAO FLORESTAL PESCA ...23.05.1494.86614.0110.0NaNNaNNaNNaNNaN3.03.03.00.00.00.00.00.03.00.00.00.00.00.00.00.00.00.03.00.00.03.00.00.00.00.00.00.00.0437.063.0435.00177.0130.0120.0123.0123.0175.01.01.04.04.0NaN3.0NaN4.00.0NaNNaNNaNNaNNaN3.0NaN1.0AGROPECUARIARNRN14789028.0175.01.036.15384647.50000041.0423454606628127736.028127736.05831611.1255831611.125488926.0NaNNaNNaN6.0NaNNaNNaNNaN12.012.03.03.0
592.100000NaN92.100000NaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 10.000.000,01 A R$ 30.000.000,00BOASOCIEDADE EMPRESARIA LIMITADAALTASERVICOS ADMINISTRATIVOSACIMA DE 1 ANOVERDE2005-09-242508.11930000.01140000.0TrueTrueFalseFalseTrueFalseFalseFalseFalseTrueNAOFalseFalseFalseFalseTrueTrueNaNNaN3.0128.04.077ed856930ed9c2b5348eca951d152b5655c98af3bb446...NaN3.022.032.029.027.015.03.03.01.0> 2020.03013792.10000061.092.10000092.100000NaN46.50000092.10000032.0930000.01140000.01.00.048.73333348.733333NaNNaN930000.01.140000e+061.00.039.17160517.072138NaNNaN22.700000930000.01140000.01.00.023.466667-0.500000NaNNaNENTIDADES EMPRESARIAISSERVICOS DE ESCRITORIO DE APOIO ADMINISTRATIVO...VALE DO ACRERIO BRANCOATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEME...48.049.6350.37396.00.0NaNNaNNaNNaN2.01.01.00.00.00.00.00.00.01.00.00.00.01.00.00.00.00.00.01.00.00.00.01.00.00.00.00.00.00.0261.00.0261.07135.0135.0189.00.00.0135.01.01.02.01.01.01.0NaN2.00.0NaNNaNNaNNaNNaN2.0NaN1.0SERVIÇOACAC930000.0135.01.00.000000-28.5714290.0000005634519679112.019679112.0NaNNaN141536.0NaNNaNNaN6.0NaNNaNNaNNaN2.04.03.03.0
6NaNNaNNaNNaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 10.000.000,01 A R$ 30.000.000,00BOACONDOMINIO EDILICIOALTASERVICOS ADMINISTRATIVOSACIMA DE 1 ANOVERDE1999-12-061185.57NaNNaNFalseTrueFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseFalseFalseNaNNaN4.077.025.0099927213e8cf60291e8241bc78a1d92da8fbb2826ae30...3.0NaN9.015.018.024.022.04.08.03.015 a 2018.906849NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN322.2000005027.166667NaNNaNNaNNaNNaNNaN93.83396278.721077NaNNaN3.933333NaNNaNNaNNaN3.933333-0.533333NaNNaNENTIDADES SEM FINS LUCRATIVOSSERVICOS PARA EDIFICIOS E ATIVIDADES PAISAGIST...LESTE POTIGUARNATALATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEME...23.027.3672.64514.011.0NaNNaNNaNNaN15.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN408.024.0407.00106.0119.0199.0NaNNaN106.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNSERVIÇORNRNNaN106.0NaN-10.924370-46.73366821.3333336661918700308.018700308.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
7110.933333NaN110.933333NaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 10.000.000,01 A R$ 30.000.000,00BOASOCIEDADE EMPRESARIA LIMITADAALTACOMERCIO POR ATACADOACIMA DE 1 ANOVERDE2004-12-241374.23210000.0210000.0TrueTrueFalseFalseTrueFalseFalseFalseFalseTrueNAOFalseFalseFalseFalseTrueTrueNaNNaN4.021.017.0d85ce0e92df9ddc051b211f1a5e3d9f223d7efd4c99245...2.0NaN5.05.012.012.03.0NaN1.02.0> 2021.947945110.93333358.0110.933333110.933333NaN44.000000110.93333330.0210000.0210000.0NaNNaN212.933333212.933333NaNNaN210000.02.100000e+05NaNNaN78.92403139.840373NaNNaN3.933333210000.0210000.0NaNNaN3.933333-0.566667NaNNaNENTIDADES EMPRESARIAISCOMERCIO POR ATACADO EXCETO VEICULOS AUTOMOTOR...NaNNaNCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...24.035.7164.29161.07.0NaNNaNNaNNaNNaN1.01.00.00.00.00.00.00.01.00.00.00.00.00.00.00.00.00.01.00.00.00.01.00.01.01.00.00.00.0118.014.0118.0543.052.058.0NaNNaN57.01.01.04.01.01.01.0NaN4.00.0NaNNaNNaNNaNNaN2.0NaN1.0COMERCIORORO210000.042.0NaN-17.307692-25.86206930.1075277666410261987.013538405.0NaNNaN672056.0NaNNaNNaN6.0NaNNaNNaNNaN13.013.03.03.0
845.666667NaN45.666667NaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 10.000.000,01 A R$ 30.000.000,00BOASOCIEDADE EMPRESARIA LIMITADAALTACOMERCIO VAREJISTAACIMA DE 1 ANOVERDE2004-04-24NaN210000.0210000.0FalseFalseFalseFalseTrueFalseFalseFalseFalseFalseNAOFalseFalseFalseFalseFalseTrueNaNNaN14.064.016.0ccbfe46d5e42b751ffe2a742680e853f50ac12e9399c2e...NaN5.016.028.016.011.013.01.02.02.015 a 2019.61095945.66666745.045.66666745.666667NaN41.66666745.66666739.0210000.0210000.0NaNNaN170.300000170.300000NaNNaN210000.02.100000e+05NaNNaN48.91844024.691643NaNNaN2.166667210000.0210000.0NaNNaN2.166667-0.433333NaNNaNENTIDADES EMPRESARIAISCOMERCIO VAREJISTANaNNaNCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...26.023.4076.60352.028.0NaNNaNNaNNaNNaN1.01.00.00.00.00.00.00.01.00.00.00.00.00.00.00.00.00.01.00.00.00.01.00.00.01.00.00.00.0258.020.0258.0194.087.099.0NaNNaN94.01.01.03.01.01.02.0NaN3.00.0NaNNaNNaNNaNNaN3.0NaN1.0COMERCIORORO210000.094.0NaN8.045977-5.05050522.2222228689526067096.026277096.0NaNNaN217142.0NaNNaNNaNNaNNaNNaNNaNNaN11.011.05.05.0
9NaNNaNNaNNaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 10.000.000,01 A R$ 30.000.000,00BOAMUNICIPIOALTAADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIALACIMA DE 1 ANOAZUL2005-10-14353.66NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseFalseTrueNaNNaN35.053.063.03aafa3a1f12f483740a52956af100223333d0e3c79bf2c...14.0NaNNaNNaN8.018.029.022.031.029.0> 2043.854795NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN506.9666675014.966667NaNNaNNaNNaNNaNNaN189.020309316.503220NaNNaN31.333333NaNNaNNaNNaN31.3333338.733333NaNNaNOUTROSADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIALCENTRO NORTE PIAUIENSEVALENCA DO PIAUIADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL23.073.5126.49176.00.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN25.00.025.00151.0151.0151.0NaNNaN151.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNSERVIÇOPIPINaN151.0NaN0.0000000.0000000.0000009742924418584.024418584.0NaNNaN87223.0NaNNaNNaNNaNNaNNaNNaNNaN1.01.02.02.0

Last rows

coligada_mais_antiga_ativacoligada_mais_antiga_baixadacoligada_mais_nova_ativacoligada_mais_nova_baixadade_faixa_faturamento_estimadode_faixa_faturamento_estimado_grupode_indicador_telefonede_natureza_juridicade_nivel_atividadede_ramode_saude_rescenciade_saude_tributariadt_situacaoempsetorcensitariofaixarendapopulacaofaturamento_est_coligadosfaturamento_est_coligados_gpfl_anttfl_emailfl_eppfl_ltdafl_matrizfl_mefl_meifl_optante_simeifl_optante_simplesfl_passivel_issfl_rmfl_safl_simples_irregularfl_spafl_st_especialfl_telefonefl_veiculograu_instrucao_macro_analfabetograu_instrucao_macro_desconhecidograu_instrucao_macro_escolaridade_fundamentalgrau_instrucao_macro_escolaridade_mediagrau_instrucao_macro_escolaridade_superiorididade_acima_de_58idade_ate_18idade_de_19_a_23idade_de_24_a_28idade_de_29_a_33idade_de_34_a_38idade_de_39_a_43idade_de_44_a_48idade_de_49_a_53idade_de_54_a_58idade_emp_catidade_empresa_anosidade_maxima_coligadasidade_maxima_sociosidade_media_coligadasidade_media_coligadas_ativasidade_media_coligadas_baixadasidade_media_sociosidade_minima_coligadasidade_minima_sociosmax_faturamento_est_coligadosmax_faturamento_est_coligados_gpmax_filiais_coligadosmax_funcionarios_coligados_gpmax_meses_servicosmax_meses_servicos_allmax_vl_folha_coligadosmax_vl_folha_coligados_gpmedia_faturamento_est_coligadosmedia_faturamento_est_coligados_gpmedia_filiais_coligadosmedia_funcionarios_coligados_gpmedia_meses_servicosmedia_meses_servicos_allmedia_vl_folha_coligadosmedia_vl_folha_coligados_gpmeses_ultima_contratacacomin_faturamento_est_coligadosmin_faturamento_est_coligados_gpmin_filiais_coligadosmin_funcionarios_coligados_gpmin_meses_servicosmin_meses_servicos_allmin_vl_folha_coligadosmin_vl_folha_coligados_gpnatureza_juridica_macronm_divisaonm_meso_regiaonm_micro_regiaonm_segmentonu_meses_rescenciapercent_func_genero_fempercent_func_genero_mascqt_admitidosqt_admitidos_12mesesqt_alteracao_socio_180dqt_alteracao_socio_365dqt_alteracao_socio_90dqt_alteracao_socio_totalqt_artqt_coligadasqt_coligadosqt_coligados_agropecuariaqt_coligados_atividade_altoqt_coligados_atividade_baixoqt_coligados_atividade_inativoqt_coligados_atividade_medioqt_coligados_atividade_mt_baixoqt_coligados_ativoqt_coligados_baixadaqt_coligados_ccivilqt_coligados_centroqt_coligados_comercioqt_coligados_eppqt_coligados_exteriorqt_coligados_inaptaqt_coligados_industriaqt_coligados_ltdaqt_coligados_matrizqt_coligados_meqt_coligados_meiqt_coligados_nordesteqt_coligados_norteqt_coligados_nulaqt_coligados_saqt_coligados_serviçoqt_coligados_sudesteqt_coligados_sulqt_coligados_suspensaqt_desligadosqt_desligados_12mesesqt_ex_funcionariosqt_filiaisqt_funcionariosqt_funcionarios_12mesesqt_funcionarios_24mesesqt_funcionarios_coligadosqt_funcionarios_coligados_gpqt_funcionarios_grupoqt_ramos_coligadosqt_regioes_coligadosqt_sociosqt_socios_coligadosqt_socios_femininoqt_socios_masculinoqt_socios_pepqt_socios_pfqt_socios_pjqt_socios_pj_ativosqt_socios_pj_baixadosqt_socios_pj_inaptosqt_socios_pj_nulosqt_socios_pj_suspensosqt_socios_st_regularqt_socios_st_suspensaqt_ufs_coligadossetorsg_ufsg_uf_matrizsum_faturamento_estimado_coligadastotaltotal_filiais_coligadostx_crescimento_12mesestx_crescimento_24mesestx_rotatividadeUnnamed_0_xUnnamed_0_yvl_faturamento_estimado_auxvl_faturamento_estimado_grupo_auxvl_folha_coligadosvl_folha_coligados_gpvl_frotavl_idade_maxima_socios_pjvl_idade_media_socios_pjvl_idade_minima_socios_pjvl_potenc_cons_oleo_gasvl_total_tancagemvl_total_tancagem_grupovl_total_veiculos_anttvl_total_veiculos_antt_grupovl_total_veiculos_levesvl_total_veiculos_leves_grupovl_total_veiculos_pesadosvl_total_veiculos_pesados_grupo
556NaNNaNNaNNaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 30.000.000,01 A R$ 100.000.000,00BOASOCIEDADE EMPRESARIA LIMITADAALTACOMERCIO E REPARACAO DE VEICULOSACIMA DE 1 ANOVERDE2005-11-031660.52NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseFalseNAOFalseFalseFalseFalseFalseTrueNaNNaN15.032.010.035bbd387f8a4cf454f781fbb75952f7efcadd9dabdfc6b...4.01.03.08.08.05.04.09.013.02.0> 2040.720548NaN79.0NaNNaNNaN59.500000NaN40.0NaNNaNNaNNaN359.066667359.066667NaNNaNNaNNaNNaNNaN123.55614098.280351NaNNaN7.666667NaNNaNNaNNaN7.6666670.766667NaNNaNENTIDADES EMPRESARIAISCOMERCIO E REPARACAO DE VEICULOS AUTOMOTORES E...OESTE POTIGUARMOSSOROCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...23.015.7984.2195.01.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN38.04.038.0257.060.063.0NaNNaN141.0NaNNaN2.0NaNNaN2.01.02.00.0NaNNaNNaNNaNNaN2.0NaNNaNCOMERCIORNRNNaN57.0NaN-5.000000-9.5238106.83760755645495624212520.056646990.0NaNNaN100694.0NaNNaNNaNNaNNaNNaNNaNNaN4.016.01.01.0
557NaNNaNNaNNaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 10.000.000,01 A R$ 30.000.000,00BOACONDOMINIO EDILICIOALTASERVICOS ADMINISTRATIVOSACIMA DE 1 ANOVERDE2007-02-081149.72NaNNaNFalseTrueFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseTrueTrue1.0NaN16.060.028.01e36b2c6ecf8630e2f7c02cd759a81ad2e7acc8bf773b1...3.01.011.022.019.021.014.05.07.02.010 a 1511.726027NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN442.266667442.266667NaNNaNNaNNaNNaNNaN76.50825450.578340NaNNaN2.200000NaNNaNNaNNaN2.200000-0.366667NaNNaNENTIDADES SEM FINS LUCRATIVOSSERVICOS PARA EDIFICIOS E ATIVIDADES PAISAGIST...LESTE POTIGUARNATALATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEME...23.016.1983.81257.011.0NaNNaNNaNNaN1.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN152.05.0152.00105.099.0119.0NaNNaN105.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNSERVIÇORNRNNaN105.0NaN6.060606-11.7647064.90196155745500221327624.021327624.0NaNNaN265726.0NaNNaNNaNNaNNaNNaNNaNNaN0.00.00.00.0
558634.300000NaN14.566667NaNDE R$ 500.000.000,01 A 1 BILHAO DE REAISDE R$ 500.000.000,01 A 1 BILHAO DE REAISBOASOCIEDADE ANONIMA ABERTAALTAELETRICIDADE E GASACIMA DE 1 ANOVERDE2005-11-031777.607.780736e+099.656361e+09FalseFalseFalseFalseTrueFalseFalseFalseFalseFalseSIMFalseFalseFalseFalseFalseTrueNaNNaN64.0333.0372.0feb26abd3bfc64f12982f55a2368816d6ecb7e008965c2...35.08.046.0118.0144.0161.0108.037.052.060.0> 2052.035616634.30000065.0129.215196129.215196NaN55.50000014.56666741.01.999183e+092.629286e+09135.03907.0506.433333506.433333313031800.0572342800.01.144226e+081.420053e+088.861111383.071429139.020260166.4267373.307499e+075.637028e+072.733333164000.0210000.01.01.02.733333-0.066667185457.661819.2ENTIDADES EMPRESARIAISELETRICIDADE GAS E OUTRAS UTILIDADESLESTE POTIGUARNATALELETRICIDADE E GAS24.024.7175.291421.051.0NaNNaNNaNNaN65.068.068.00.00.00.00.00.00.068.00.00.00.02.00.00.00.048.00.068.00.00.06.00.00.056.018.062.00.00.0651.090.0649.029770.0815.0857.03986.010726.0788.014.02.013.0164.02.08.09.011.02.02.00.00.00.00.010.0NaN6.0INDUSTRIARNRN7.780736e+09769.0319.0-5.521472-10.15169211.399620558456630500805000.0516073630.07.937997e+081.578368e+099215811.022.66119121.8603721.059548NaNNaNNaNNaNNaN167.0168.016.016.0
559481.033333NaN99.566667NaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 10.000.000,01 A R$ 30.000.000,00BOASOCIEDADE EMPRESARIA LIMITADAALTACOMERCIO VAREJISTAACIMA DE 1 ANOVERDE2005-08-273071.988.209219e+069.349219e+06FalseFalseFalseFalseTrueFalseFalseFalseFalseFalseSIMFalseFalseFalseFalseFalseTrueNaNNaN2.064.03.06c0463d509136d232f05962554b6c3e94c04c1627ad9a3...1.01.03.015.011.014.07.07.08.02.0> 2042.723288481.03333371.0264.744444264.744444NaN49.66666799.56666737.07.789219e+068.719219e+061.048.0444.3000005064.7000002596406.52596406.52.736406e+063.116406e+061.00000024.00000096.74975837.1787952.596406e+062.596406e+067.166667210000.0210000.01.00.07.166667-0.7333332596406.52596406.5ENTIDADES EMPRESARIAISCOMERCIO VAREJISTACENTRO AMAZONENSEMANAUSCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...24.059.4240.58449.02.0NaNNaNNaNNaN1.03.03.00.00.00.00.00.00.03.00.00.00.02.00.00.00.00.00.03.00.00.00.03.00.00.01.00.00.00.0380.07.0380.0969.075.099.048.048.0117.03.01.03.03.01.02.0NaN3.00.0NaNNaNNaNNaNNaN3.0NaN1.0COMERCIOAMAM8.209219e+0669.02.0-8.000000-30.3030309.79021055945708521018528.029660482.02.596406e+062.596406e+06294723.0NaNNaNNaNNaNNaNNaNNaNNaN6.06.01.01.0
56056.200000NaN56.200000NaNDE R$ 30.000.000,01 A R$ 100.000.000,00DE R$ 30.000.000,01 A R$ 100.000.000,00BOASOCIEDADE EMPRESARIA LIMITADAALTASERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOSACIMA DE 1 ANOVERDE2006-02-01NaN9.300000e+059.300000e+05FalseTrueFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseTrueFalseNaNNaN150.0127.02.0f3b468c4066fac0d2de28bdafa87ec8b9d103a085cf7de...34.0NaN6.021.026.045.041.043.044.019.010 a 1512.74520556.20000049.056.20000056.200000NaN41.00000056.20000033.09.300000e+059.300000e+05NaNNaN5099.0666675099.066667NaNNaN9.300000e+059.300000e+05NaNNaN173.80967761.097177NaNNaN20.733333930000.0930000.0NaNNaN24.700000-0.566667NaNNaNENTIDADES EMPRESARIAISSERVICOS DE ARQUITETURA E ENGENHARIA TESTES E ...CENTRO AMAZONENSEMANAUSATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS23.063.4436.56981.00.0NaNNaNNaNNaNNaN1.01.00.00.00.00.00.00.01.00.00.00.00.00.00.00.00.00.01.00.00.00.01.00.00.01.00.00.00.0702.08.0702.00279.0287.0296.0NaNNaN279.01.01.02.01.0NaN2.0NaN2.00.0NaNNaNNaNNaNNaN2.0NaN1.0SERVIÇOAMAM9.300000e+05279.0NaN-2.787456-5.7432432.82685556045791740955220.040955220.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
561596.233333NaN16.700000NaNDE R$ 300.000.000,01 A R$ 500.000.000,00DE R$ 500.000.000,01 A 1 BILHAO DE REAISBOASOCIEDADE ANONIMA FECHADAALTAINDUSTRIA DIGITALACIMA DE 1 ANOVERDE2008-01-145985.495.223031e+095.451955e+09FalseTrueFalseFalseTrueFalseFalseFalseFalseTrueSIMTrueFalseFalseFalseTrueFalseNaNNaN140.02447.0563.0251f454db948590c50df496ea83f76e2227e24a32c2814...5.07.0643.0949.0749.0444.0200.095.041.017.010 a 1510.794521596.23333372.0106.631111106.631111NaN52.50000016.70000035.05.150974e+095.372531e+09275.01716.030.333333146.600000171568880.0241816100.03.482021e+083.634637e+0824.000000361.60000023.34154118.2843453.669588e+075.131406e+073.433333210000.0210000.01.010.03.433333-0.466667288489.6288489.6ENTIDADES EMPRESARIAISATIVIDADES DE PRESTACAO DE SERVICOS DE INFORMACAONORTE MARANHENSEAGLOMERACAO URBANA DE SAO LUISINFORMACAO E COMUNICACAO23.033.5666.445340.0465.0NaNNaNNaNNaNNaN15.015.01.00.00.00.00.00.015.00.00.08.01.00.00.00.010.00.015.00.00.04.01.00.010.03.02.00.00.02168.0394.02162.063172.03186.03460.01229.01808.03787.07.04.05.028.0NaN4.0NaN5.00.0NaNNaNNaNNaNNaN4.0NaN5.0SERVIÇOMAMA5.223031e+093150.0288.0-0.439422-8.32369912.561773561460027459934850.0560530400.01.834794e+082.565703e+08NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
56258.266667NaN58.266667NaNDE R$ 30.000.000,01 A R$ 100.000.000,00DE R$ 30.000.000,01 A R$ 100.000.000,00NaNSOCIEDADE EMPRESARIA LIMITADAALTACOMERCIO POR ATACADOACIMA DE 1 ANOVERDE2003-04-02NaN3.770971e+063.770971e+06FalseFalseFalseFalseTrueFalseFalseFalseFalseFalseSIMFalseFalseFalseFalseFalseTrueNaNNaN14.0149.05.0fab2fcabc509768ba2943a21e674fb5af79cb349873048...7.05.013.019.021.035.029.017.012.010.015 a 2015.58356258.26666753.058.26666758.266667NaN53.00000058.26666753.03.770971e+063.770971e+06NaN21.0182.433333182.4333331256990.41256990.43.770971e+063.770971e+06NaN21.00000050.48333324.6749311.256990e+061.256990e+062.2333333770971.23770971.2NaN21.02.233333-0.6666671256990.41256990.4ENTIDADES EMPRESARIAISCOMERCIO POR ATACADO EXCETO VEICULOS AUTOMOTOR...CENTRO AMAZONENSEMANAUSCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...23.013.6986.31606.044.0NaNNaNNaNNaN1.01.01.00.00.00.00.00.00.01.00.00.00.01.00.00.00.00.00.01.00.00.00.01.00.00.00.00.00.00.0436.042.0436.00170.0173.0177.021.021.0168.01.01.02.01.0NaN1.0NaN2.00.0NaNNaNNaNNaNNaN1.0NaN1.0COMERCIOAMAM3.770971e+06168.0NaN-1.734104-3.95480224.85207156246099753164510.053164510.01.256990e+061.256990e+06NaNNaNNaNNaNNaNNaNNaNNaNNaN0.00.018.018.0
563536.733333NaN346.366667NaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 10.000.000,01 A R$ 30.000.000,00BOASOCIEDADE EMPRESARIA LIMITADAALTABENS DE CONSUMOACIMA DE 1 ANOAZUL2005-11-03814.858.281920e+051.248192e+06FalseTrueFalseFalseTrueFalseFalseFalseFalseFalseSIMFalseFalseFalseFalseTrueTrueNaNNaN14.0104.09.0564fde999c34d33a262dad0e1596029b2b5f92e4f0aed6...5.01.010.023.027.015.017.014.05.010.0> 2023.698630536.73333360.0441.550000441.550000NaN58.500000346.36666757.06.181920e+058.281920e+051.04.0443.033333443.033333247276.8247276.84.140960e+056.240960e+051.0000004.00000087.90210051.2026562.472768e+052.472768e+052.266667210000.0420000.01.04.02.266667-0.433333247276.8247276.8ENTIDADES EMPRESARIAISFABRICACAO DE PRODUTOS ALIMENTICIOSLESTE POTIGUARNATALINDUSTRIAS DE TRANSFORMACAO23.022.8377.17365.034.0NaNNaNNaNNaNNaN2.02.00.00.00.00.00.00.02.00.00.00.01.00.00.00.01.00.02.00.00.02.00.00.00.00.00.00.00.0238.019.0237.00127.0112.0153.04.04.0127.02.01.02.02.01.01.0NaN2.00.0NaNNaNNaNNaNNaN2.0NaN1.0INDUSTRIARNRN8.281920e+05127.02.013.392857-16.99346415.89958256346106627658940.027658940.02.472768e+052.472768e+0572226.0NaNNaNNaNNaNNaNNaNNaNNaN2.02.02.02.0
564NaNNaNNaNNaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 100.000.000,01 A R$ 300.000.000,00NaNSERVICO SOCIAL AUTONOMOALTASERVICOS DE EDUCACAOACIMA DE 1 ANOVERDE2000-04-032323.03NaNNaNFalseTrueFalseFalseTrueFalseFalseFalseFalseTrueNAOFalseFalseFalseFalseTrueTrueNaNNaN3.016.073.031438f752b4a846638c0acd98c3078d7e1ee83204e0388...2.0NaN1.08.018.017.019.016.05.06.015 a 2018.580822NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN300.466667373.766667NaNNaNNaNNaNNaNNaN69.31123254.917612NaNNaN2.066667NaNNaNNaNNaN2.066667-0.433333NaNNaNENTIDADES SEM FINS LUCRATIVOSEDUCACAONaNNaNEDUCACAO23.059.7840.22388.05.0NaNNaNNaNNaN4.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN296.030.0296.01092.0118.0132.0NaNNaN482.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNSERVIÇORORONaN92.0NaN-22.033898-30.30303028.70813456446144326530740.0108877850.0NaNNaN1603418.0NaNNaNNaNNaNNaNNaNNaNNaN17.019.02.02.0
565323.066667NaN74.166667NaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 10.000.000,01 A R$ 30.000.000,00BOASOCIEDADE EMPRESARIA LIMITADAALTAINDUSTRIA DA CONSTRUCAOACIMA DE 1 ANOVERDE2005-11-034315.606.189792e+066.609792e+06FalseFalseFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseFalseTrue1.0NaN69.065.02.08a226339b331b5aec24877a69edc40070b9dd7e71b2194...4.0NaN14.020.023.020.022.011.014.09.0> 2041.164384323.06666768.0191.375000191.375000NaN66.50000074.16666765.05.563728e+065.773728e+061.045.0258.033333258.0333332781864.02781864.01.547448e+061.652448e+061.00000012.00000036.16861311.3359411.442448e+061.442448e+064.866667206064.0210000.01.00.04.866667-5.566667103032.0103032.0ENTIDADES EMPRESARIAISCONSTRUCAO DE EDIFICIOSCENTRO NORTE PIAUIENSETERESINACONSTRUCAO23.05.1194.891844.014.0NaNNaNNaNNaN2.04.04.00.00.00.00.00.00.04.00.02.00.00.00.00.00.00.00.04.00.00.04.00.00.00.02.00.00.00.01707.05.01706.06137.0128.0511.048.048.0137.03.01.02.04.01.01.0NaN2.00.0NaNNaNNaNNaNNaN2.0NaN2.0CONSTRUÇÃO CIVILPIPI6.189792e+06137.02.07.031250-73.1898243.77358556546183419782144.022572144.02.884896e+062.884896e+06100470.0NaNNaNNaNNaNNaNNaNNaNNaN1.01.00.00.0